Posted by kb on 08/25/07 05:00

>I have inherited a SQLS erver 2000 instance where the client never
> implemented a backup startegy for the "master" and "msdb" databases.
> MSDB is now showing errors and my only option for a restore is from a
> tape backup of the server.

see:

Books Online > Restoring the model, msdb, and distribution Databases:
http://msdn2.microsoft.com/en-us/library/aa173499(SQL.80).aspx


--
Tom
http://kbupdate.info/ | http://suppline.com/

[Back to original message]