Topology optimal sql servers separated by 10000 km

1

Hello everyone and thanks in advance for your answers.

I describe the situation that arises to me. I have 4 bbdd that I have to keep exactly the same between two separate 10000km servers.

  • The size of these together are 200 GB (One of them, the largest, 130 GB)
  • The sql are 2016
  • They must be accessible in read / write mode all of them.

What solution would you give? If you need more information consult me.

    
asked by Jose Luis Arenas 08.05.2017 в 11:17
source

1 answer

0

For what you indicate, I would recommend a peer-to-peer transactional replication, to meet the requirements that they be exactly the same and that all four databases are accessible in read / write mode.

The only thing is that the edition of SQL Server 2016 is required to be Enterprise Edition, which, if you do not have them currently licensed as such, may incur an additional cost.

In the product documentation, exactly Peer-to-Peer -Transactional Replication , you can find more information on how to configure and use this replication scheme. There is even a diagram similar to your requirement in the topologies section.

    
answered by 10.05.2017 в 11:28