sql2005 日志文件损坏
2021-01-15 07:40:57
61
alter database dbname set emergency
use master
declare @databasename varchar(255)
set @databasename='dbname'
exec sp_dboption dbname, N'single', N'true'
dbcc checkdb(dbname,REPAIR_ALLOW_DATA_LOSS)
dbcc checkdb(dbname,REPAIR_REBUILD)
exec sp_dboption dbname, N'single', N'false'