Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Full Backup WAN Copy for Log Shipping - Interim Backups

Posted on 2013-11-23
1
Medium Priority
?
334 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
[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
1 Comment
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

597 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