• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

Full Backup WAN Copy for Log Shipping - Interim Backups

I will be doing a full backup of a 39 Gb database ( compressed) over a WAN connection to a remote location to setup log shipping.  It will take about 15 hours to copy.  I know that during that time I cannot do any log backups but I assume I can do differentials without affecting the LSN for log shipping?
0
Primedius
Asked:
Primedius
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
Hi,

Indeed, you can do differentials but please note that you can also take copy-only log backups also - you need to use BACKUP LOG <db_name> TO DISK = '<log backup location>' WITH COPY_ONLY .

Please note that COPY_ONLY log backup doesn't truncate trasaction log.

Regards,
Daniel
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now