1

I am using SQL Server 2008 R2 and would like to log ship from my local data center SQL instance to a log shipping target SQL Server running in AWS EC2.

What is the best way to copy the log ship files from the local SQL Server to the remote EC2 instance?

I have seen plenty of 'how to copy a file to EC2' solutions, but am wondering what is the best method for continuous unattended file copying (such as SQL Server T-Log files every 15 minutes).

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Pete Lunenfeld
  • 1,557
  • 3
  • 19
  • 32

1 Answers1

1

I'm doing this today using an S3 bucket and AWS CLI with the sync command. You have to configure AWS on each machine and make sure the credentials file is under the user folders of the account that the SQL Agent is running under. The simply add the Powershell call as a step in the SQL LS job to either put or get the files depending on the machine you are on (local or EC2). I also recommend staggering the EC2 machine job so it runs ~5 mins after the LS job on the source server.

sqlSnakeHandler
  • 11
  • 3