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.

Comments

Popular posts from this blog

How To Bypass Windows 30 day Activation / Product Key Requirements

How to Run Hiren’s BootCD From a USB Flash Drive (USB Pen Drive)

Complete Guide to the Windows Shutdown Command – Explained with Easy Examples