Помогло с восстановление SQL баз....
How to Attach a SQL Server Database without a Transaction Log and with Open Transactions: "USE master
GO
DBCC TRACEON(3604)
GO
ALTER DATABASE TestDB_Repair SET EMERGENCY
GO
ALTER DATABASE TestDB_Repair SET SINGLE_USER
GO
DBCC CHECKDB('TestDB_Repair', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS
GO
ALTER DATABASE TestDB_Repair SET MULTI_USER
GO"
'via Blog this'
No comments:
Post a Comment