Learning Home: SQL SERVER database suspect problem solution.

Wednesday, 26 April 2017

SQL SERVER database suspect problem solution.

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



Note: BeaconAcc is DBName.

No comments:

Post a Comment