Click here to Skip to main content
15,886,664 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
how to recover sql server database in suspect mode ?
Posted

1 solution

 
Share this answer
 
Comments
azizulhoque.bd 8-Dec-12 2:39am    
hi..

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

I complete this process but i can not understand how to recover or backup my database. When I backup my database then message show emergency mode is active so backup is not success.
azizulhoque.bd 11-Dec-12 2:40am    
thanks, good for reply.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900