SHARE
TWEET

SR - Error Database(Suspect)

EmilianoRoldanR Aug 24th, 2019 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --SR - Error Database(Suspect)
  2.  
  3. EXEC SP_RESETSTATUS  softrestaurant95pro;
  4.  
  5. ALTER DATABASE softrestaurant95pro SET EMERGENCY;
  6.  
  7. DBCC CHECKDB (softrestaurant95pro);
  8.  
  9. ALTER DATABASE softrestaurant95pro SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
  10.  
  11. DBCC CHECKDB (softrestaurant95pro, REPAIR_ALLOW_DATA_LOSS);
  12.  
  13. ALTER DATABASE softrestaurant95pro SET MULTI_USER;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top