March 24, 2016 at 9:20 am
At the moment the backup from our logshipping is created on a local drive and, using dropbox, populates the two servers where we have our secondary databases.
I now want to stop using Dropbox and create the backup transaction files directly on the servers.
From what I can see, Sqlserver will only allow one logshipping instance for a database when I will need two as there will be two separate backups which is not allowed.
Does anybody know a way that I can create two instances of the logshipping?
March 24, 2016 at 4:31 pm
Log shipping is simply backup, copy, restore. You can have multiple secondaries, you just have multiple copy and restore jobs:
"The log can be shipped to multiple secondary server instances. In such cases, operations 2 and 3 are duplicated for each secondary server instance."
March 29, 2016 at 11:59 am
For you current set up, you can back up the logs to a shared network drive or local. Replace the dropbox with a windows job to transfer files to secondary nodes. If you have SQL Server log shipping set up, all this should happen automatically.
April 4, 2016 at 3:10 pm
You only want/need to do one backup you just need too do two restores. So backup DB logs to network share and have the two other servers both restore from that one file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply