T-SQL 恢复数据库

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