SQL Server Performance Forum – Threads Archive

Multi site replication question

Hi all,
What is the best way to get data across multiple datacenter located accross USA. What methodology is best to use. both Database has to be in sync incase of fail-over and load balancing. Along with multi site, it also has to be able to server multiple servers within same website to do load balancing. Databases are heavy for reads and writes, so task of each Db would be devided by application purpose, but all applications uses data from each other. Thanks,
Aziz

What version of SQL SErver you want to use in this regard?
Are there any other processess involved in this data replication?
DO you have any existing replication in place? Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I currently have MS SQL 2000 running. I would like to implement this on SQL 2005 as our company is looking to move to that. also, There are no replication currently running. Just a log shipping job for a backup DB server.
Thanks

If it is a new replication setup on SQL 2005 then refer to the updated books online for SQL 2005 version, as you have much information and also Google is your best friend for blog postings. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>