1

I usually use redgate sql backup which has a transaction log copy mechanism built in.

If I roll my own log shipping, what are established ways to move the log file?

I want to emphasize: The way log shipping works in the log shipping feature is a mess. The requirement of a file share, and all the firewall and auth overhead of that are simply over the top.

In my dreams, there would be an automatic way to do log shipping via azure files. Click click click. Think how great this would be:

1) No file shares needed! 2) Your backups and tran logs are automatically backed up in azure cloud (DR step #1 !) 3) The remote can be anywhere 4) I can now easily do one-to-many log shipping, because the point to point architecture of the built in log shipping is side stepped.

1

I had the same requirement as a component for our Disaster Recovery solution. Due to security and policy reasons, it was not possible to use regular Log Shipping.

We ended up transferring the logs via Linux servers and rsync, and implementing the Log Backup restore using a small application which can be found at https://github.com/kervinpierre/mssqlapplylogs

  • 1
    This is not the log shipping of my dreams, but it is close! We are getting a lot closer to using azure , with the new file share function of azure. Then we can use encrypted backups and log backups, pushed to azure via robocopy, then pulled form azure with robocopy, and use your script to apply them. – samsmith Jan 19 '16 at 6:37
2

If I roll my own log shipping, what are established ways to move the log file?

Why do you want to roll out your own logshipping solution ? Microsoft has put in a lot of effort for giving out-of-box Logshipping from SQL 2005 and up. This is tested by millions of customers since sql 2005, so highly unlikely you will encounter any bugs with it.

You can refer to : Step By Step SQL Server Log Shipping for how to configure native logshipping.

References for Custom Logshipping :

Using Powershell :

  • 1
    Why roll my own log shipping? Because the built in mechanism requires a file share. I am now shipping to TWO destinations, one via Azure blob storage, the other via file system... gotsta roll my own.... (MS native doesnt have anything useful for log shipping over azure) – samsmith Jan 23 '15 at 17:02
  • I am now shipping to TWO destinations, one via Azure blob storage, the other via file system... gotsta roll my own you did not mention anything about azure in your question :-) – Kin Shah Jan 24 '15 at 7:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.