Contact support

Networking & Infrastructure

Database reports as SUSPECT

Database reports as SUSPECT

24 July 2019 11:14

Run this script substituting database name

EXEC sp_resetstatus horio_uk_heath; ALTER DATABASE horio_uk_heath SET EMERGENCY ALTER DATABASE horio_uk_heath SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CHECKDB (horio_uk_heath, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE horio_uk_heath SET MULTI_USER