I have a setup transactional replication, the subscriber (pulled subscription) is used for reporting.
My problem is, I would like to setup Mirroring on the publisher DB to another server for failover.
Though it possible to use the subscriber as failover, but I find it tedious to implement (e.g., reseeding of identity column).
Is a good idea to mirror the publisher DB while it is used in transactional replication? Or is there a better approach?
Your comments and suggestions are highly appreciated.