Standard Operating procedure for doing a maintenance plan (SQL 2005)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rocky5 - 30 Jul 2008 21:31 GMT

Hi;

Can anyone point me to a template for a Standard operating procedure and
maintenance plan to keep SQL running healthy
These are steps or common tasks done by an admin or a power user

Thanks a bunch

Rock

Reply to this Message

Andrew J. Kelly - 31 Jul 2008 01:33 GMT

Well there is no "standard" per say as many sites have different
requirements and limitations. For instance if the site is 24x7 you may do
things differently than one that is 9 to 5. Here is a good document that
might help you decide. Although it is written for 2000 most still applies
for 2005 as well.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Hi;
>
[quoted text clipped - 5 lines]
>
> Rock

Reply to this Message