Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping - Point In Time Recovery Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 5:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 68, Visits: 316
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?
Post #1477948
Posted Friday, July 26, 2013 6:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:34 AM
Points: 6,166, Visits: 13,309
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"
Post #1477957
Posted Friday, July 26, 2013 7:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:19 AM
Points: 68, Visits: 316
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.

Post #1477984
Posted Friday, July 26, 2013 7:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:25 AM
Points: 6, Visits: 143
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.
Post #1477994
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse