解决方案: |
重新附加提示3624错误,需要重建日志文件,用以下sql语句(--附加数据库提示3624错误,需要重建日志
sp_configure ''allow'', 1
reconfigure with override
update sysdatabases set status = 32768
where name = ''UFDATA_002_2007''
DBCC REBUILD_LOG (''UFDATA_002_2007'', ''G:UFDATA1.LDF'' )
restore database UFDATA_002_2007 WITH RECOVERY
GO
update sysdatabases set status = 4194316 where name = ''UFDATA_002_2007''
sp_configure ''allow'', 0
reconfigure with override
GO
sp_dboption @dbname = ''UFDATA_002_2007'',
@optname = ''single user'' ,
@optvalue = ''true''
use UFDATA_002_2007
GO
DBCC CHECKDB( ''UFDATA_002_2007'',REPAIR_ALLOW_DATA_LOSS)
go
sp_dboption @dbname = ''UFDATA_002_2007'',
@optname = ''single user'' ,
@optvalue = ''false''
) |