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.
Any thoughts..
>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).as px
--
Tom
http://kbupdate.info/ | http://suppline.com/