--step 1, go in emergency mode ALTER database [ActivePos_write] set SINGLE_USER Alter database [ActivePos_write] SET EMERGENCY --step 2, do a checkdb DBCC CHECKDB ('ActivePos_write') WITH NO_INFOMSGS, ALL_ERRORMSGS --if no errors reported or index corruption, do a repair with data loss DBCC CHECKDB ('ActivePos_write', REPAIR_ALLOW_DATA_LOSS) --set the db back in multi user ALTER database [ActivePos_write] set multi_user