question

shwetha avatar image
shwetha asked

Transactional Replication with Asynchronous mirroring

Hi All, I need your help on this. I have the Asynch mirroring with transactional replication(push subscription with remote distributor) set up in sql 2008 r2 enterprise test environment. When principal server goes down, i manually force the service on to the mirror server. Replication failsover as a part of mirroring. When the principal comes up ,both are in suspended state. I resume the mirroring on the new principal(former mirror) ,replication works fine,but when I see the log reader agent status from the GUI on new principal it prmopts to connect to distributor and when I try to connect it doesn connect and thereare no logs as well. When I want to see the synchronization status on the new principal push subscription it throws error 'an error occurred while attempting to access subscription(view synchronization status) the subscription does not exist(view synchronization status) without the error code. how to resolve this?
replicationmirroring
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.