The database was in suspect mode, inaccessible
Ran the following query
Then restored from the latest full back up
EXEC sp_resetstatus client_367
ALTER DATABASE client_367 SET EMERGENCY
use client_367
DBCC checkdb
ALTER DATABASE client_367 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('client_367', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE client_367 SET MULTI_USER
This blog is created to add all the information and experiences that I have learnt while working on MS sql server as a DBA. The blog is also updated frequently with the real world problem that I encounter hands on at work and the resolutions to resolve them. I hope this blog will be of some use to you and you will revisit. Thank you for stopping by and you are welcome to leave comments.
Wednesday, June 11, 2014
Recovery database from suspect mode
Labels:
Administration,
Backup database,
corrupt,
error,
recovery,
suspect mode
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment