Advertisement
Guest User

Untitled

a guest
Apr 26th, 2015
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. EXEC sp_resetstatus 'msdb'
  2.  
  3. ALTER DATABASE msdb SET EMERGENCY
  4.  
  5. DBCC CheckDB ('msdb')
  6.  
  7. ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  8.  
  9. DBCC CheckDB ('msdb', REPAIR_ALLOW_DATA_LOSS)
  10.  
  11. ALTER DATABASE msdb SET MULTI_USER
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement