Add new comment

Repair MS SQL Corrupted or Suspected Database

Submitted by Divya on Thu, 20/04/2017 - 18:31

Execute the below query by replacing the 'test' with the database name. EXEC sp_resetstatus 'test' ALTER DATABASE test SET EMERGENCY DBCC CheckDB ('test') ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ('test', REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE test SET MULTI_USER

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.