Solved

SQL 2000 msdb (Suspect)

Posted on 2008-10-09
4
1,678 Views
Last Modified: 2013-11-16
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.
0
Comment
Question by:SD_Bolts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:lnkevin
ID: 22687880
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
 

Author Comment

by:SD_Bolts
ID: 22789733
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
 
LVL 26

Accepted Solution

by:
lnkevin earned 500 total points
ID: 22789917
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
 

Author Closing Comment

by:SD_Bolts
ID: 31504758
I was able to restore the file with the assistance of an individual who is more advanced than I in SQL Databases.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question