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

Katie 1 gravatar image

Katie 1
1.4k 132 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, 2010 at 12:59 PM

DaniSQL gravatar image

DaniSQL
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, 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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 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, 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.

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1841
x729
x126
x86

asked: May 17, 2010 at 11:53 AM

Seen: 1294 times

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