SQL database marked as suspect?

I want help in repairing SQL 2005 database marked as suspect. I have tried starting it many times and every time it opens as suspect mode that too after a long attempt of recovery. From the error log I could know about database inconsistency, anyone with ideas on how to repair it since command DBCC checkDB does not work in suspect mode?

646 day ago

Comment(s) (0)

Report Abuse

Find Intereseting

E-Mail to Friends

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet !!! Be the first to comment

Answers (1)

spriyasen

You should first restart SQL server service this may resolve the issue. However you must look into event log to find out the reason behind db getting to suspect mode.

Next the database then has to be reset as follows
• EXEC sp_resetstatus ‘database name’

• Reset SQL server service is then executed

• DBCC DBRECOVER ‘database name’

This will remove the suspect mark and now you can do mySql repair with DBCC checkDB. By specifying the drive name where database is present so that it is scanned for detection of errors and the same will accordingly be fixed and now you can work the my Sql database normally after restarting it.

Posted 646 days ago

( 0 )