New User ? Sign Up  |  Sign In  |  Help
ask
Ask whatever question, you wish. Make sure you select the correct category for the question.
answer
Like to help other, then browse through the open questions to answer their questions.
discover
Find answer by browsing the resolved questions.
     
Search for questions :
My Profile
Categories

Celine

Open Question Bookmark and Share

Marked Suspected Error in MS SQL Database ?

When I connected to the MS SQL Database and was trying to open the SQL Server management Studio, I am getting the following error message: “Database ‘msdb’ not found: It has been marked suspect”. After that when I am viewing the event log of SQL Server application, I am getting a further error message like: “Log Scan Number (152:284:1) in database ‘msdb’ is not valid”.

As a result of these error messages, I am not able to access to the SQL database. I want to know what the possible reason behind this mess and how to get rid of this problem. Has anybody used Stellar Phoenix SQL Repair utility tool? Were you able to fix your problems using this utility tool?

969 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

Elisha 		These error messages are occurring because either there is some kind of corruption in the SQL database or the error log file is not able to match up with the database file. In order to get rid of this problem, you can use an inbuilt tool called sp resetstatus. By using this tool you can get access to the damaged database by enabling you to change the status of the SQL database. But the only disadvantage using this tool is that you will be only able to connect to the SQL Server and you can access the other databases.

Couple of months back when I was not able to get access to the files in the SQL database due to virus attack, I had used this Stellar Phoenix software. All the damaged files of mine were repaired very efficiently by this software and I am really satisfied with its working. You can check out this Stellar Phoenix SQL Repair Software; though this is not the ultimate utility tool. There are many other 3rd party utility tools available for MS SQL Database Repair like Kernel, Data Nucleus etc.


Posted 969 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0