I have one server, in which there are three instances of SQL Server 2019. In one instance, I had configured transactional replications, but all of those replications are currently dropped. But the replication monitor is still showing the old configured replications.

Also, when I am refreshing the monitor, then publisher is getting disconnected from its distributor and I have to reconnect again. Sometimes, I am connecting the publisher to the distributor using "Connect to Distributor" option and its getting disconnected automatically. In such case, I am trying to connect to distributor many times till I am able to see the wrong list of publications. I am sharing screen shots to clarify the issue below:

enter image description here

As shown in above screen shot, under Local Publicatons folder, there are no Publication, whereas Replication Monitor is showing 4 Publications which are no more existing. Please suggest.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.