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

Best Selling Products

CredoID Version 4.x is the latest open systems Access Control Platform that integrates to any environment via a free API Interface. The best selling single door controller is without question the HID Mercury LP1501 PoE+ Controller