Replicating data to colo

Last Post 02 Apr 2013 10:17 AM by samuelh. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
samuelh
New Member
New Member

--
01 Apr 2013 02:01 PM
Hi all,

Trying to determine the best way to handle database "replication" to a colo for disaster recovery as well as database access to remote offices.

Currently I have a production SQL server 2008 R2 and have log shipping setup in the same server room on a different identical server for redundancy. The databases are of course in read only mode and of course I'd need to recover them from read only mode to full access in case of emergency for local apps.

However, with business growing and databases growing as well, I've been asked to look into replicating 3 databases to a colo and maybe to remote offices. To colo, because of disaster recovery and access to web apps. In case our redundant ISPs are down, clients still would be able to access our site and database from the Colo location.

Also we do have remote offices where they're going to be running local apps and write to local databases and replicate the data in both directions, from main offices to remote offices vice-versa.

I have looked into all the methods that MS SQL server offers and I think Merge Replication is what fits to our need.

I just wanted to see if anyone has any input or any recommendation. Main important thing is to have our local databases replicated outside our local server room and be able to write and read from any location and sync the data.

Many thanks in advance.
rm
New Member
New Member

--
02 Apr 2013 05:38 AM
Take look at peer to peer replication.
gunneyk
New Member
New Member

--
02 Apr 2013 06:42 AM
I agree with rm in that you should give peer to peer a good look before going with Merge. There are pro's & con's to each but in many environments P-P is easier to manage and does just fine.
samuelh
New Member
New Member

--
02 Apr 2013 07:45 AM
Both rm and gunneyk..........thanks much!

I will definitely look into peer-to-peer. I'm hoping that Peer-to-peer is available with SQL server 2008 R2 standard version. I only have license for Standard and not Enterprise. I believe this feature of replication was introduced in SQL 2005 with Enterprise edition.
samuelh
New Member
New Member

--
02 Apr 2013 10:17 AM
Unfortunately Peer-to-peer is not supported with the standard version of SQL server. That just leaves me with Merge Replication option I guess.


Acceptable Use Policy
---