question

Katie 1 avatar image
Katie 1 asked

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-2008sqladministrationjob
10 |1200 characters needed characters left characters exceeded

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

DaniSQL avatar image
DaniSQL answered

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

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

I missed that there wasn't a consistency check? I am an idiot. That's one of the most important.
1 Like 1 ·
Grant Fritchey avatar image
Grant Fritchey answered

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

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

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 Likes 0 ·
Yeah, pretty much.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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