Hi, we are running a 70GB database on SAPDB 7.4.03.31. Due to the fact that our hardware for this server is not very powerful, I have a few questions regarding backup and reorganisation.
Currently we are first running database verify, afterwards database backup and update statistics, which runs at least for 50 hours. Is this order (1st verify, 2nd backup and 3d update statistics) right? Howto stop the update statistics process correctly? Verify needs 18 hours, backup needs 4 hours and the update statistics need 30 hours. The weekly data increment is between 0.8GB and 1.0GB. Do we need to run verify and update statistics every week? Kind regards, Timo ___________________________________________________________ Timo Denis, IT department DBA / Developer / Administrator [LPIC1] IEE S.A. International Electronics & Engineering Zone Industrielle, L-6468 Echternach, Luxembourg Phone +(352)72 89 89-6801, Fax +(352)72 89 89-6109 This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
