[MS-SQL] 주의대상 복구

EXEC sp_resetstatus 'yourDBname';

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb('yourDBname')

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER



**출처**
http://webee.tistory.com/58
http://blog.daum.net/jungsangun/7691128
http://cafe.naver.com/teamsystem.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=125&