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.

🌟 Struggling with 100% Disk Usage on Windows 10/11? Here’s What Worked for Me…

  🌟 Struggling with 100% Disk Usage on Windows 10/11? Here’s What Worked for Me… Not long ago, my laptop became incredibly slow, almost to ...