Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
puja
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. |
|
eyechart
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.-ec |
|
|
puja
Starting Member
18 Posts |
Posted - 2005-10-04 : 15:38:48
|
thanks |
|
|
bakerjon
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!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013 |
|
|
|
|
|