Repair Corrupted Database

Consult with Management before giving this out to clients or running on someones server!!!

DBCC CHECKDB (’DBNAME) WITH NO_INFOMSGS, ALL_ERRORMSGS

ALTER DATABASE DBNAME  SET EMERGENCY 

DBCC checkdb('DBNAME') 

ALTER DATABASE DBNAME  SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

DBCC CheckDB ('DBNAME'), REPAIR_ALLOW_DATA_LOSS) 

ALTER DATABASE DBNAME SET MULTI_USER 

Or

1. Detach database and move your mdf to save location. 

2. Create new database of same name, same files, same file location and same file size. 

3. Stop SQL server. 

4. Swap mdf file of just created DB to your save one. 

5. Start SQL. DB will go suspect. 

6. ALTER DATABASE yourdb SET EMERGENCY 

7. DBCC checkdb('DBNAME') 

8. ALTER DATABASE yourdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

9. DBCC CHECKDB (yourdb, REPAIR_ALLOW_DATA_LOSS) 

10. ALTER DATABASE yourdb SET MULTI_USER 

11. ALTER DATABASE yourdb SET ONLINE