速达软件账套修复 sql2005 日志文件损坏问题
2023-03-13 09:07:19
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'