HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Tail-log backup options when restoring to a new database

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
newlogoptionsrestoringdatabasetailwhenbackup

Problem

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!

Solution

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.

Context

StackExchange Database Administrators Q#211180, answer score: 6

Revisions (0)

No revisions yet.