USE master
GO
ALTER DATABASE DEMO SET SINGLE_USER
GO
ALTER DATABASE DEMO SET EMERGENCY
GO
DBCC CHECKDB(DEMO,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE DEMO SET ONLINE
GO
ALTER DATABASE DEMO SET MULTI_USER
GO
ALTER DATABASE AIS20121023174212 SET SINGLE_USER
GO
ALTER DATABASE AIS20121023174212 SET EMERGENCY
GO
DBCC CHECKDB(AIS20121023174212,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE AIS20121023174212 SET ONLINE
GO
ALTER DATABASE AIS20121023174212 SET MULTI_USER
GO
ALTER DATABASE AIS20180714140303 SET SINGLE_USER
GO
ALTER DATABASE AIS20180714140303 SET EMERGENCY
GO
DBCC CHECKDB(AIS20180714140303,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE AIS20180714140303 SET ONLINE
GO
ALTER DATABASE AIS20180714140303 SET MULTI_USER
GO
ALTER DATABASE DAHECode SET SINGLE_USER
GO
ALTER DATABASE DAHECode SET EMERGENCY
GO
DBCC CHECKDB(DAHECode,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE DAHECode SET ONLINE
GO
ALTER DATABASE DAHECode SET MULTI_USER
GO
ALTER DATABASE DSCSYS SET SINGLE_USER
GO
ALTER DATABASE DSCSYS SET EMERGENCY
GO
DBCC CHECKDB(DSCSYS,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE DSCSYS SET ONLINE
GO
ALTER DATABASE DSCSYS SET MULTI_USER
GO
ALTER DATABASE DSCSYS SET SINGLE_USER
GO
ALTER DATABASE DSCSYS SET EMERGENCY
GO
DBCC CHECKDB(DSCSYS,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE DSCSYS SET ONLINE
GO
ALTER DATABASE DSCSYS SET MULTI_USER
GO
ALTER DATABASE HunTec SET SINGLE_USER
GO
ALTER DATABASE HunTec SET EMERGENCY
GO
DBCC CHECKDB(HunTec,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE HunTec SET ONLINE
GO
ALTER DATABASE HunTec SET MULTI_USER
GO
ALTER DATABASE K3DBConfiger SET SINGLE_USER
GO
ALTER DATABASE K3DBConfiger SET EMERGENCY
GO
DBCC CHECKDB(K3DBConfiger,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE K3DBConfiger SET ONLINE
GO
ALTER DATABASE K3DBConfiger SET MULTI_USER
GO
ALTER DATABASE KDAcctDB SET SINGLE_USER
GO
ALTER DATABASE KDAcctDB SET EMERGENCY
GO
DBCC CHECKDB(KDAcctDB,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE KDAcctDB SET ONLINE
GO
ALTER DATABASE KDAcctDB SET MULTI_USER
GO
ALTER DATABASE LearunFramework_Base_2017 SET SINGLE_USER
GO
ALTER DATABASE LearunFramework_Base_2017 SET EMERGENCY
GO
DBCC CHECKDB(LearunFramework_Base_2017,REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE LearunFramework_Base_2017 SET ONLINE
GO
ALTER DATABASE LearunFramework_Base_2017 SET MULTI_USER
GO
恢复数据库
原文：https://www.cnblogs.com/yunyun0574/p/9522988.html
