Archives

Posts Tagged ‘database’

Run the following SQL statements to fix the issue: EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(’yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (’yourDBname’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE yourDBname SET MULTI_USER   Please see here for more details. It worked for my database and I was able to repair successfully.

Aug 13th, 2012 | Filed under Windoze