Maintenance tasks

Question

question

Katie 1 asked May 17, '10

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,

sql-server-2008 sql administration job

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-05-17T12:59:16Z

DaniSQL answered May 17, '10

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.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · May 17, 2010 at 01:30 PM

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

1 ·

Answer 2 · 2010-05-17T12:02:27Z

Grant Fritchey answered May 17, '10

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.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Slick84 commented · May 17, 2010 at 01:14 PM

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?

0 ·

Grant Fritchey ♦♦ commented · May 17, 2010 at 01:30 PM

Yeah, pretty much.

0 ·

question