1.ALTER DATABASE posdb SET EMERGENCY
2.DBCC checkdb(posdb)
3.ALTER DATABASE posdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5.ALTER DATABASE posdb SET MULTI_USER
This is the command for all data base recover from suspect . First rename db with suspect db name and then Execute query one by one , then it is solved with out any data lose.
No comments:
Post a Comment