Hi,

This is my scenerio.

SQL Server A and SQL Server B must have transactional replication inplace so that when tables data changes in Server A, Server B will have the same data created. And Vice Versa.

My Question: I want to ensure that I am able to replicate changes made to either Server A tables or Server B tables if either server goes down.

Do I set up transactional replication and merge replication ?


Thanks,

Alvin