How to Fix a Suspect or Corrupt Database

Database, Knowledge Base

Run this query:

EXEC sp_resetstatus [AMDB]

ALTER DATABASE [AMDB] SET EMERGENCY

DBCC checkdb([AMDB])

ALTER DATABASE [AMDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ([AMDB], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [AMDB] SET MULTI_USER

Investor Relations

Middleware Associates, LLC. is a privately held corporation that was founded by Patrick Conners in January, 2004. For information reqarding a potential merger, acquisition or an investment in our future technology please Contact Us