Options

I need to restore a significant number of rows deleted from a table by accident earlier today.

Rod_Anderson

Rod_Anderson Posts: 2 New member

November 13, 2019 5:29PM in SQL Log Rescue

At least some of these lines would not be in the backup created very early this morning.

Tagged:

Redgate

0 ·

Answers

Options
Rod_Anderson Posts: 2 New member

November 13, 2019 6:00PM

I've selected all the deleted transactions in the table in question, but when I try to launch the query in the query analyzer it comes up blank

0 · Share on Twitter
Options
Jessica R Posts: 1,319 Rose Gold 4

November 28, 2019 12:25AM

Hi @Rod_Anderson!

Is your database using the Full Recovery model? If so and you've taken regular Full / Diff / Log backups, you can perform a point in time restore.

You may also be able to use Object Level Recovery, but please note the limitations with the feature listed here: https://documentation.red-gate.com/sbu10/tools-and-utilities/object-level-recovery/recovering-objects

Jessica Ramos | Product Support Engineer | Redgate Software

Have you visited our Help Center?

0 · Share on Twitter

Sign In or Register to comment.