Solved

Log Shipping Backups as part of Weekly Backup Plan

Posted on 2013-11-14
2
364 Views
Last Modified: 2013-11-21
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...
0
Comment
Question by:Primedius
2 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39650624
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
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 39665087
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question