<div>
I would certainly look at differential backups to help keep the number of files to restore down. Potentially a daily differential.<br />
<br />
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi Everyone,<br />
<br />
We currently do one weekly backup followed by hourly trans log backups for a weekly rotation.<br />
<br />
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. &nbsp;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?<br />
<br />
Thanks in advance...
</div>
</div>


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...

Log Shipping Backups as part of Weekly Backup Plan

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.