quote:

---

Originally posted by Carat

Explanation of our system:
We have a production server (Server1) that is located within our building. We have another server (ServerA) which is a dedicated server hosted by another company. Between Server1 and ServerA there is a replication on tables between several databases. We have snapshot, transactional replication and transactional replication with updatetable subscriptions. Besides replication we have another way to export data. We use a Clr to make a rar-file from our table at Server1 and this file is copied to the other server and there it is Bulk Imported. This can be compared with snapshot replication. This Clr runs several times a day to synchronise the 2 server.

replication
Server1 ----------- ServerA

Now we have another dedicated server (ServerB) that is also hosted by the same company. ServerB must be equal to ServerA. This means that any update that takes place at ServerA must also be done at ServerB. Users can connect to ServerA or ServerB.

My questions:
1:) How can this be done? Should I use replication like this:

Transaction replication
Server1 (publication) ----------- ServerA (subscription)
----------- ServerB (subscription)

This looks good considering the fact you have good network bandwidth.

2:) My boss asked me whether there is a mechanism that can make ServerA equal at all time to ServerB by using something like RAID1 (Mirroring). The 2 servers must be accessible at all time. I think this is not the case when you use Database Mirroring or Log Shipping.

Yes you are right.

3.) How do the large companies manage there servers to make them equal? When you have for example 20 sql server, and all off them must be equal and must be accessed by users, how can this made possible?

Though our company is not so big, We deal with synchronizing Max 5 SQL server. We use Merge Replication for it. We are planning to change it to Peer-to-Peer Replication.

---

quote:

---

Originally posted by Carat

Ok thanks.

Is it possible to replicate certain tables with peer-to-peer replication or can you only replicate all the tables at once?

---