I am setting up transactional replication on a database A with read only subscriber database B (for reporting purpose). I have also setup mirror on database A. I tried to manually failover to mirror...mirroring works fine but transactional replication is interrupted.
I have followed the steps as in article
http://msdn2.microsoft.com/en-us/library/ms151799.aspx
I have also used PublisherFailoverPartner parameter...but replication still complains that it cannot connect to publishing database.
Any ideas or direction is greatly appreciated.
I would trouble shoot the following way:
1) try to connect to the old mirror (which is the new principal after the failover) database from the distributor (for example using osql.exe) and see if connection can be made. This will eliminate the obvious connection issue.
2) check to see if the server that hosted the mirrored database was configured as publisher using the same distributor
No comments:
Post a Comment