[MSSQL] 복구작업

2016. 3. 18. 13:20DB/MSSQL

alter database ermsdb set emergency;

go


alter database ermsdb set single_user

go


dbcc checkdb('ermsdb', repair_allow_data_loss) with all_errormsgs;

go


alter database ermsdb set multi_user;

go