Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use to perform your database maintenance. Please be as specific as possible, including what steps you perform, in what order, and how often you typically perform them. By sharing your database maintenance procedures, we can all learn from each other.
Post your responses to the above SQL Server Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.
Because there is no right or wrong answer, this month’s winner will be selected randomly from all the entries that are received.
| This Month’s Prizes | The prizes this month are an Amazon.com voucher worth US$50.00 and a license for new SQL Monitor 2.0, with one year of support and upgrades (to be released in November). SQL Monitor’s unique web UI enables you to monitor your servers whenever, wherever, with up-to-the minute performance data and intelligent alerts |
