Sql-server – Can replication be set up when already mirroring

mirroringreplicationsql serversql-server-2012

We currently use SQL Server 2012 Standard Edition and we mirror from one SQL Server instance to another for automatic failover purposes.

I want to replicate the database which is mirrored, to another SQL Server instance, for reporting purposes. The replication will need to be as close to real time as possible.

Questions

  • Can you have SQL Server replication working alongside mirroring?
  • If so, how does it function and does it have constraints / impact on the mirroring?

Best Answer

You can absolutely setup transactional replication on mirrored publishing databases. It is fully supported, and Microsoft has some good content on getting it up and running.

The only caveats are the ones that already exist for transactional replication, and the recommendation to have the distributor database on another server outside of the mirrored pair.