sql server - Rollback transaction using transaction log

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Would it be possible rollback transactions using Transactionlog file for a particular record?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

438 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T18:34:52+0000

Natively, no. I believe there are some pricey third party tools to do this, though.

Alternatively, you can restore your DB from a backup, and then RESTORE LOGS to a point in time with the STOPAT = '6/30/2009 2:30PM' argument.

There are Apex and SQL Log Rescue available. If your logs aren't in FULL recovery mode, though, you may be up a creek if you can't restore.