Saturday, February 16, 2019

How To Recover Pasdb Suspect


1.ALTER DATABASE posdb SET EMERGENCY
2.DBCC checkdb(posdb)
3.ALTER DATABASE posdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
4.DBCC CheckDB (posdb, REPAIR_ALLOW_DATA_LOSS)
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.

?? Desktop Support Services – A Complete Professional Guide By Kamal Roy

  💻 Desktop Support Services – A Complete Professional Guide By Kamal Roy Desktop Support is one of the most important entry-level roles ...