What should be included in an ideal mainteance script? Our weekly maintance script has the following: Defrag Index, dbcc checkdb, update statistics. Is there anything else we should include? Current DB size is approx 35GB. Any suggestions for daily maintenance as well. The only daily job we have is full backup. If it helps, heavy transactions (update/insert/delete/select) occurs last two weeks of the month. Any professional suggestions would be much appreciated!
Welcome to the forums. I would suggest to take help of a script thatn to DB maintenance plan with SSIS packages: See below http://sqlserver-qa.net/blogs/tools...database-maintenance-tasks-more-features.aspx http://sqlserver-qa.net/blogs/tools...-jobs-without-database-maintenance-plans.aspx to start with...
Welcome to the forums!. Since you have sql 2000, your actual maintenance plan is OK. If you have any window in working days, I suggest to include update statistics (only heavy tables). I presume your Update Statistics on week end is with "full scan"
