Log Shipping Backups as part of Weekly Backup Plan

Hi Everyone,

We currently do one weekly backup followed by hourly trans log backups for a weekly rotation.

It appears now that we need to log ship that same database to an offsite location and I understand the hourly log backups will bugger that up so we need stop that.  My question is if we set the delete window on the log shipping backups to just greater than a week can we use the logs in the ls folder to restore if needed to?

Thanks in advance...
PrimediusAsked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Yes. The log backups taken by the log shipping process are the same as if you'd taken a log backup yourself. You may want to consider doing differential backups periodically too, as restoring a weeks worth of hourly log backups is going to be laborious if you ever need to do it.
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
I would certainly look at differential backups to help keep the number of files to restore down. Potentially a daily differential.

Tlog backups are important to keep for that purpose and you can use the same logs for Log Shipping as said above. Log Backups are log backups and you can use them for whatever purpose you want.
0
All Courses

From novice to tech pro — start learning today.