Solved

Full Backup WAN Copy for Log Shipping - Interim Backups

Posted on 2013-11-23
1
324 Views
Last Modified: 2013-11-24
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
Comment
Question by:Primedius
1 Comment
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 39672641
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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

912 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now