Prev: subscription is searching for an old snapshot
Next: reinitialize a merge subscription
From: Xavier on 15 Jun 2010 09:14
Hi everybody,

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
 | 
Pages: 1
Prev: subscription is searching for an old snapshot
Next: reinitialize a merge subscription