Help to choose best replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Help to choose best replication

Hi All,
I have configured failover cluster. My manager is asking to replicate all database to other on server which is not in same domain. I want replication as same as original database to another one server.
The new server is used to diaster recovery. Which replication method is best?
Are Some other methods available other than replication? I am using SQL Server 2005 Enterprise Edition.
Thanks
S. Ramesh
Hi Ramesh, I was invetsigating this couple of months ago, anyways used the following links to get a fair idea. http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=1&faqid=97 Cheers
Sat
Why don’t you take help of database mirroring in this case to addup additional layer of availability to the current cluster environment. Is there any specific reason to go for replication only? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Transactional replication is the best method but you have to have PK to replicate… You can take the help of Database mirroring or log shipping but the databases will not be available to read all the time for any other purposes like reporting… Cluster helpful only when there is a problem with the server but not with disk…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

As Mohammed and Satya have said, Replication is not really a high availability solution [unless it’s peer-ro-peer replication, which yours wouldn’t be]. Definitely you need to go for database mirroring or log shipping. If you have SQL Server 2005 Enterprise Edition you can create snapshots of the mirrored database for reporting if you want.
Thanks for all your help. I am going to install database mirror. Thanks
S. Ramesh
For the sake of budgets you can even get rid of cluster if the database mirroring had setup properly without any issues. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>