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

[Rocky5]

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

[Andrew J. Kelly]

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

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Rocky5" <nos...@msnnews.com> wrote in message
news:%233W5$Mo8IH...@TK2MSFTNGP03.phx.gbl...