SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log Shipping - Point In Time Recovery


Log Shipping - Point In Time Recovery

Author
Message
wak_no1
wak_no1
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 353
Hi

We have Log Shipping as one of our DR solutions. Basically, we take a TL backup every 15 minutes to our DR server, we keep a maximum of 3 days worth of TL backups, which we're looking to extend to 10 days, so that we can roll the Production database back further back in time.

What is the best method In restoring the Production database to a specific point in time? Would I need to apply the backup of the night before, then apply the TL up until the required restore time?
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50654 Visits: 17653
please provide full schedule details of any scheduled backups that occur so that a restore path may be suggested

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
wak_no1
wak_no1
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 353
A full back is initiated 10 minutes past midnight every night, current retention is 3 days, where then the backup are copied off to to tape. We're looking at storing at least 10 days worth of backups and logs (as part of Log Shipping).

So, in theory, should the client need to roll back to a certain period in the past 10 days, they can do.
Joechelad
Joechelad
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 155
I would restore the latest full backup from the previous night and then apply the transaction logs that were backed up sequentially so that all logs will be restored with no recovery with the exception of the last one in the sequence so that it can be restored 'with recovery' to make the database available for the users.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search