19/03/2015 How to Repair Suspect Database in SQL Server Using DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS ­ MyTechMantra.

com

Home SQL Server Articles Whitepapers BizTalk Articles SharePoint Articles Buy Books Advertise Contact Us

Search

How to repair a Suspect Database in SQL Server

By: Editor
March 25, 2010

Page: 2/2

New WhitePaper "Demystify TempDB Performance And Manageability"

4. Execute the DBCC CHECKDB command which will check the logical and physical integrity of all
the objects within the specified database. Newsletter Signup
email address
DBCC CHECKDB ﴾BPO﴿
GO Subscribe
"Receive newsletters and special
offers about SQL Server, BizTalk and
SharePoint from MyTechMantra. We
respect your privacy and you can
5. Next step will be to bring the user database in SINGLE_USER mode by executing the below unsubscribe at any time."

mentioned TSQL code.

ALTER DATABASE BPO SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

Highly Recommended:‐ You can avoid this isuue in future by using a Free Tool
"SQL Integrity Check".

6. Once the database is in SINGLE_USER mode execute the below TSQL code to repair the
database. When you repair your database using REPAIR_ALLOW_DATA_LOSS option of DBCC
CHECKDB command there can be some loss of data. Once the database is successfully repaired
using REPAIR_ALLOW_DATA_LOSS option of DBCC CHECKDB command then there is no way to
go back to the previous state.

DBCC CHECKDB ﴾BPO, REPAIR_ALLOW_DATA_LOSS﴿

GO

7. Finally, execute the below mentioned TSQL command to allow MULTI_USER access to the
database.

ALTER DATABASE BPO SET MULTI_USER

MORE SQL SERVER TROUBLESHOOTING ARTICLES
GO
ALSO READ ... STEPS TO REBUILD SYSTEM DATABASES IN SQL SERVER
DETECT VIRTUAL LOG FILES IN SQL SERVER TRANSACTION LOG FILE

SIG N UP T O DAY F O R MYT ECHMANT RA.CO M NEWSL ET T ER

L IKE US O N F ACEBO O K | F O L L O W US O N T WIT T ER

http://www.mytechmantra.com/LearnSQLServer/Repair_Suspect_Database_P2.html 1/2
19/03/2015 How to Repair Suspect Database in SQL Server Using DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS ­ MyTechMantra.com

Free Tools

Trainings

Free Whitepapers

Introduction to SQL
Server Statistics
Moving SQL Server to a
Virtual Platform
Conclusion 5 DBA Mistakes That Can
Cost You Your Job
In this article you have seen how you can recover a database which is marked SUSPECT. Data Quality 101: The
Ultimate Guide for Data
Stewards
Six Steps to Managing
Data Quality with SQL
Server Integration
Services
Idera SQL Elements
Review: A SQL Server
Inventory Management
Solution

Connect with US

Click on Previous Page button to read this article from the beginning... Follow @MyTechMantra

Continue Free Learning...

Please leave below your valuable feedback for this article.

Feel Free to refer this article to your friends and colleagues using the below “Share this
Article” option.
Do subscriber to our News Letter to continue your free learning.
Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article

Geeks who read this article also read…

How to Downgrade SQL Server Database from a higher version to a lower version
Steps to Rebuild System Databases in SQL Server
Enforce Password Policies and Password Expiration for SQL Server Logins
Microsoft SQL Server Build Versions
Auditing SQL Server Logins
Uninstalling SQL Server 2008
Database Backup Compression Feature In SQL Server 2008
Read More SQL Server Articles…

Privacy Disclaimer Advertise Contact Us Copyright © MyTechMantra.com All rights reserved.

http://www.mytechmantra.com/LearnSQLServer/Repair_Suspect_Database_P2.html 2/2