解决SQL日志文件损坏的问题

USE MASTER
GO
SP_CONFIGURE ‘ALLOW UpdateS’,1 RECONFIGURE WITH OVERRIDE
GO
Update SYSDATABASES SET STATUS =32768 Where NAME=’数据库名”
Go
sp_dboption ‘数据库名”, ‘single user’, ‘true’
Go
DBCC CHECKDB(‘数据库名”)
Go
update sysdatabases set status =28 where name=’数据库名”
Go
sp_configure ‘allow updates’, 0 reconfigure with override
Go
sp_dboption ‘数据库名’, ‘single user’, ‘false’
Go