SQL 2000 msdb (Suspect)
Posted on 2008-10-09
I have one Server (MS Windows Server 2003, Standard Edition) with SQL 2000. The other day the servers drive where SQL is hosted ran out of disk space. I was able to make some room for now to get things up and running again. I was updating information to another database when I noticed that the msdb was marked (Suspect). I have tried to both back it up from a back up tape and to restore the database through SQL and a back up software.
I was reading another post on the subject and tried to run the Quarry Analyzer but the msdb database did not show up in the list. I know there are other post on the subject but my experience with SQL is very limited. I suspect that this is causing one of my other databases in the same SQL to run at limited capacity.