Replicating a database that uses Fail Over We are trying to setup replication for data coming in from an outside vendor. The issue that we are having is they say that because our vendor is using SQL Fail Over Clustering so they claim that the DB cant be replicated? Is that true and is there any work arounds.
That is not true. I've done transactional replication with FCIs for years. Interestingly I cannot find any supporting documentation on the Microsoft site, however it is supported, and it does work.