sql修復(fù)數(shù)據(jù)庫語句
來源：原創(chuàng) 發(fā)布時(shí)間:2017-03-22 09:28:27
use master
go
sp_dboption ufdata_111_2016,single,true
ALTER database ufdata_111_2016 set single_user with rollback immediate
ALTER database ufdata_111_2016 set multi_user with rollback immediate
DBCC CHECKDB
DBCC CHECKDB (\'ufdata_001_2016\',repair_fast)
DBCC CHECKDB (\'ufdata_001_2016\',repair_rebuild)
DBCC CHECKDB (\'ufdata_001_2016\',repair_allow_data_loss)
