|
Guys, I wanted to know what are the different maintenance tasks that are run on the database servers on regular intervals. The ones I know are database backups, rebuilding indexes on timely manner. I am working on standards, to make them as routine processes. Thanks,
(comments are locked)
|
|
I suggest you add regular Integrity check(Daily or weekly depending on the size of your database) and Disk space monitoring to your maintenance schedule. Edit: Also Make sure you come up with a plan to test your backups regularly. I missed that there wasn't a consistency check? I am an idiot. That's one of the most important.
May 17 '10 at 01:30 PM
Grant Fritchey ♦♦
(comments are locked)
|
|
I would also add a regular job to update statistics. You may also want to look into policy based management as a way to add another level of checks to everything you do. Hello Grant. Would it be wise to setup an SSIS package to rebuild indexes and then update statistics in one package? And then schedule this package in a SQL job to run on a specified schedule?
May 17 '10 at 01:14 PM
Slick84
Yeah, pretty much.
May 17 '10 at 01:30 PM
Grant Fritchey ♦♦
(comments are locked)
|
