All geek questions in one place

Cancel transaction

I am updating some data in a table using a transaction. The transaction log is available in ldf database files. Now, by mistake, the user made a transaction to delete records, and he received a commit, and the data was deleted. so is there any way to discard this particular transaction. Please suggest. I would really appreciate your help.

Thanks,

+3
source share
3 answers

You cannot cancel a committed transaction.

" . , , , . . , , , .

+3

SQL Server, fn_dblog DBCC LOGINFO, , . . . , .

, , , FULL BULK LOGGED

, , SQL Server Management Studio ApexSQL. , RedGate SQL Rescue. , : , , , , .

: ApexSQL

+3

, (.. ) "WITH STANDBY = 'filename" . , .

SQL 2000 , , , . - , SQL script. , , SQL (, Quest, Red Gate, Idera).

0

Source: https://habr.com/ru/post/1714280/

More articles:


All Articles