ALTER DATABASE sfgov SET SINGLE_USER
go
DBCC CHECKDB ('sfgov', repair_allow_data_loss) with NO_INFOMSGS
go
ALTER DATABASE sfgov SET MULTI_USER
go
...全文
1103打赏收藏
老是断开连接
我在ManagementStudio中用下面语句修复数据库,由于要修复很长时间,试了几次,中途始终要提示:“连接已断开”,导致命令无法运行完成,请问是怎么回事呢? ======================== ALTER DATABASE sfgov SET SINGLE_USER go DBCC CHECKDB ('sfgov', repair_allow_data_loss) with NO_INFOMSGS go ALTER DATABASE sfgov SET MULTI_USER