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!