all groups > sql server replication > march 2005 >
You're in the

sql server replication

group:

msdb is Suspect


msdb is Suspect lreames NO[at]SPAM gmail.com
3/28/2005 1:25:34 PM
sql server replication:
Is am running SQL 2000 SP3 on a Win 2000 box.

My msdb is marked suspet. I ran sp_resetstatus and restarted SQL and
the dB is still suspect.

I found an article that recommends....

One approach would be to drop & recreate the msdb databases (see
instmsdb.sql and instserv.sql in the c:\mssql\install directory of your
sqlserver install). You would lose backup/restore histories, all
operators, scheduled tasks, etc. but would get it back up and running.


Is this the only solution? Is there a way to do this without loosing
my backup history??

TIA,
Larry....
msdb is Suspect Paul Ibison
3/29/2005 12:22:26 AM
Larry,
have a look at these articles:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.a
sp
http://www.windowsitpro.com/Articles/Index.cfm?
ArticleID=492&DisplayTab=Article
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Re: msdb is Suspect lreames NO[at]SPAM gmail.com
3/29/2005 7:17:44 AM
Paul,

You are the man!!! This did the trick.

As always, thanks for your help!!!!

Larry...
AddThis Social Bookmark Button