Maintenance tasks


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.


more ▼

asked May 17 '10 at 11:53 AM in Default

Katie 1 gravatar image

Katie 1
1.4k 129 163 202

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered May 17 '10 at 12:59 PM

DaniSQL gravatar image

4.9k 33 35 39

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)
10|1200 characters needed characters left

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.

more ▼

answered May 17 '10 at 12:02 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 17 '10 at 11:53 AM

Seen: 1148 times

Last Updated: May 18 '10 at 08:08 AM