Solved

Log Shipping Backups as part of Weekly Backup Plan

Posted on 2013-11-14
2
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

717 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