How do you repair a 'Suspect' MS SQL (2005) database

Databases
1

Help!!!

My database has gone offline, it is highlighted as ‘Suspect’.

Foolishly, i haven’t got a recent back up.

Is there a way of quickly restoring the database?

Thank you

2

Start looking at the log files and see if you can identify what triggered the outage.

3

The typical way to resolve this is to set the database to emergency:

ALTER DATABASE [YOURDB] SET EMERGENCY;

Then you will want to set to single user:

ALTER DATABASE [YOURDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

Now you should be able to run DBCC CHECKDB (YOURDB). You probably want to run it first to see what is wrong before you decide how to proceed. It wouldn’t hurt to try REPAIR_REBUILD before you consider REPAIR_ALLOW_DATA_LOSS, but since it is already suspect and you don’t have a recent backup that is likely your only recourse. Once finished, be sure to set the database back to MULTI_USER.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.