Looking for help?
Table of Contents
All Topics
Print

Consistency Error

Solution

EXEC sp_resetstatus [BellDB10];
ALTER DATABASE [BellDB10] SET EMERGENCY
DBCC checkdb([BellDB10])
ALTER DATABASE [BellDB10] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([BellDB10], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [BellDB10] SET MULTI_USER