DB/MSSQL

[MSSQL] 복구작업

Lucifer_D 2016. 3. 18. 13:20
반응형

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

반응형