x

Maintenance tasks

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,

more ▼

asked May 17, 2010 at 11:53 AM in Default

avatar image

Katie 1
1.4k 132 164 205

(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, 2010 at 12:59 PM

avatar image

DaniSQL
4.9k 33 39 43

I missed that there wasn't a consistency check? I am an idiot. That's one of the most important.

May 17, 2010 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, 2010 at 12:02 PM

avatar image

Grant Fritchey ♦♦
137k 20 42 81

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, 2010 at 01:14 PM Slick84

Yeah, pretty much.

May 17, 2010 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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x2072
x987
x131
x98

asked: May 17, 2010 at 11:53 AM

Seen: 1493 times

Last Updated: May 18, 2010 at 08:08 AM

Copyright 2016 Redgate Software. Privacy Policy