6

I want to restore a sql server database(sql server 2014) to a new database to see if I can recover deleted data.

I need to restore from about 2 months ago, so I will need to use the timeline and pick the correct trn point in time.

I'm restoring to a new database and don't want to mess with or interrupt the source database at all.

So should I leave the options under Tail-log backup (Take tail-log backup before restore and Leave source database in the restoring state) unchecked or checked?

Thanks!

Improve this question

1 Answer 1

Reset to default
6

I'm restoring to a new database and don't want to mess with or interrupt the source database at all.

So should I leave the options under Tail-log backup (Take tail-log backup before restore and Leave source database in the restoring state) unchecked or checked?

Unchecked. Just enter the name of the new database you want to restore into and pick the point on the timeline.

Improve this answer
1
  • 1
    Any idea why it defaults to 'Take tail-log backup...' when the destination database is different from source? Seems unlikely to be desired.
    – Rory
    Commented Sep 10, 2021 at 10:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.