Monday, March 19, 2012

MERGE replication ON CLUSTER

HEllo!!!!
Our enterprise need build a SQL server CLUSTER (4 computers).. but
now we don't have resources to buy a DISK ARRAY.. My Question is : Is
it possible to do this using MERGE REPLICATION between each SQL
instance in each Server?.
Thanks Brian
Brian,
these are not really the same functionally as clustering is not a method of
duplicating data but if you want to prepare for disaster recovery and can't
afford a cluster I suggest checking out Log Shipping. Replication can be
used (usually transactional with queued subscribers), but we can discuss
that if you don't like the look of log shipping.
Regards,
Paul Ibison

No comments:

Post a Comment