November 13, 2010 at 6:36 pm
The scenario, I have locations in NJ,US and London with a SQL 2008R2 Server at each site. I have a primary database at each site that we are looking to replicate to a separate instance at the other office location.
NJ - SQL Server 2008R2
Instance 1 - Primary US Database
Instance 2 - Backup UK Database
_____________________________
UK - SQL Server 2008R2
Instance 1 - Primary UK Database
Instance 2 - Backup US Database
30mb WAN that is highly latent; 120ms average.
Does anyone have an recommendation as to which methods to focus on for trial and thoughts of what to look out for?
Cheers
November 13, 2010 at 7:52 pm
We have this setup in our company..., so this we have used log shipping.. i assume your backup database is in read only mode....
u can manually set up the log shipping job timing
NJ - SQL Server 2008R2
Instance 1 - Primary US Database
Instance 2 - Backup UK Database --read only mode
_____________________________
UK - SQL Server 2008R2
Instance 1 - Primary UK Database
Instance 2 - Backup US Database -- read only mode
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply