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?