My SQL Server recently suffered a raid controller/hard drive crash. After getting my hard drive problem corrected I soon found that some of my databases were (suspect) namely msdb.
I am not a DBA by any means however am somewhat familiar with the daily SQL activities that happen on my server. So I restored from backup, and tried to bring my msdb database online.
It is now forever stuck in (Loading\Suspect) and I am unable to script backups for my important databases. I can recreate all of the backup plans etc if i can somehow get a working msdb. Any help would be greatly appreciated.
I am currently using:
- Microsoft SQL Server 2000
- Version: 8.00.194
Best Answer
Follow the directions in this article. It has to do with the suspect database caused by a missing or new device. I hope this helps.
If that doesn't work, you will have to recreate the MSDB database yourself.