February 28, 2017 at 7:55 am
Basically, i will be copying all the data from a given database every 15 mins or on some predefined interval in time. The second server or the one being copied to can be read only however it must be available. I was going to do log shipping but then realized that the secondary server will be unavailable when the logs are processed. Then i thought i should do replication however it doesn't appear replication works well accross separate domains. I was wondering if anyone had a suggestions
Microsoft SQL Server 2014 (SP2-CU3) (KB3204388) - 12.0.5538.0 (X64)
Dec 15 2016 17:52:48
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
February 28, 2017 at 9:46 am
log shipping would be your best solution to be honest, the log restores can be pinned down to set times making the database available at the cost of a slight data latency
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply