Monday, April 1, 2019

How to Get DATABASE OUT OF SUSPECT MODE MS SQL SERVER 

ALTER DATABASE DBName  SET  EMERGENCY
 
DBCC CHECKDB('DBName')
 
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 
DBCC CHECKDB('DBName', REPAIR_ALLOW_DATA_LOSS)
 
ALTER DATABASE DBName SET MULTI_USER
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)