May 22, 2009 at 11:42 am
Hi masters,
we have lost the msdb.
The database is suspect.
We don't have backups of this database ,that's very strange...
What can we do?
tks,
Pedro
May 22, 2009 at 12:32 pm
Please check the SQL Server error log for some explanation of why it's suspect.
May 22, 2009 at 1:52 pm
Without backups you will have to rebuild msdb. Check out this article.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 31, 2009 at 9:08 am
ok, i think i understud the article.
One question:
If i stop the engine (that as this problem) and then copy the data file and the log file of the MSDB database of other engine, when i restart this engine (that as the bad MSDB),will the problem be solved?
May 31, 2009 at 9:48 am
It won't be suspect anymore, but you'll still have lost all of your jobs, backup history, DTS packages, SSIS packages and whatever else is stored in msdb.
Personally, I'd rather say rebuild it (check the link Jack gave) than try copying from another server. Too much chance of odd problems later.
Have you looked in the error log for the messages that state why the DB has been marked suspect? If may be something that's trivial to fix (though that is unlikely)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2009 at 3:16 pm
May 31, 2010 at 9:34 pm
Hi Sir,
is this apllicable to SQL Server7 also? please advise.
Thank you.
Kind Regards,
Len
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply