use master go sp_configure ‘allow updates‘,1 go reconfigure with override update sysdatabases set status=32768 where dbid=DB_ID(‘ypsxyy20160527‘) dbcc rebuild_log (‘ypsxyy20160527‘,‘D:\亚讯医药软件20160526\YpsxYY.ldf‘) exec sp_dboption ‘ypsxyy20160527‘, ‘single user‘, ‘false‘ update sysdatabases set status =28 where name=‘ypsxyy20160527‘ ALTER DATABASE ypsxyy20160527 SET SINGLE_USER ----??????????? DBCC CheckDB (ypsxyy20160527,REPAIR_ALLOW_DATA_LOSS) ----????? DBCC CheckDB (ypsxyy20160527),REPAIR_REBUILD) ----?? ALTER DATABASE ypsxyy20160527 SET MULTI_USER ----????? alter database ypsxyy20160527 set EMERGENCY alter database ypsxyy20160527 set online