SQL 2000 msdb (Suspect)

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.
SD_BoltsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lnkevinCommented:
When you have Suspect is when you are running out of the space again. You told us that you cleared out some space, but it suspects that the current available space does not cover the restoration and the restore is unable to complete. Login SQL command and do the following thing:

- Execute sp_resetstatus.
- Use ALTER DATABASE to add a data file or log file to the database.
- Stop and restart SQL Server.
- With the extra space provided by the new data file or log file, SQL Server should be able to complete recovery of the database.
- Free disk space and rerun recovery.

K

0
SD_BoltsAuthor Commented:
Are you referencing the Quarry Analyzer, because it will not let me do that, I am a true novice when it comes to SQL.

I am sorry for taking so long to respond, I had to depart the office for an extended period of time.
0
lnkevinCommented:
You can do it in command line, using Query Analyzer (2000) or SQL Studio (2005). Whatever way you do to run new query. If it's too advanced for you, I suggest you to hire a DBA doing it instead of messing it out.

K
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SD_BoltsAuthor Commented:
I was able to restore the file with the assistance of an individual who is more advanced than I in SQL Databases.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.