Greetings,
My publisher database is configured for mirroring. I am using transaction log replication with updatable subscriptions. The publisher fail over is working great.
My Problem: If I fail over the publisher database, so now the database that was configured first with the publication is the mirror partner, when I do an insert into the subscriber I receive an error stating it cant insert in database because it is acting as a mirror.
This tells me that the subscriber is still trying to send transaction to the original principle, which is no longer the principle anymore.
How can I configure the subscriber to know which publisher to send transactions to?
Thank You