Friday, August 11, 2017

How to Attach a SQL Server Database without a Transaction Log and with Open Transactions

Помогло с восстановление 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'