Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 ? on SystemDB Database Mainteance plan

Author  Topic 

Starting Member

18 Posts

Posted - 2005-10-04 : 12:42:50
Does systemdb plan need Integrity cheking?

would appreciate anyone help on database mainteance plan on system db.

Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-10-04 : 12:50:13
it is always a good idea. The system databases can become corrupt just as easily as the user databases.

Go to Top of Page

Starting Member

18 Posts

Posted - 2005-10-04 : 15:38:48
Go to Top of Page

Posting Yak Master

145 Posts

Posted - 2005-10-05 : 18:47:50
And stop using the maintenance planner! I highly recommend scripting out your maintenance even for small databases. I believe Tara's Blog has some replacements, if not all. Other items could be copied from those examples.

Now I know, and knowing is half the battle!

Go to Top of Page

- Advertisement -