We currently have 2 servers: A and B.
Server A contains a production version of a SQL Server 2008 database
and B contains a development version of that database.
We wish to establish a replication of these databases as
follows:
- The production database will be replicated from A to B,
- The development database will be replicated from B to A
The goal is to always have a server online for production
and development in case of failure of one or the other.
I intended to establish a transactionnal replication system, but have
never done this manipulation, I'm not sure this is the best way.
Could you tell me the advantages and disadvantages of this
method, and a better way to proceed if there is one ?
Thank you in advance