Got a problem. I have a replication that was created and then deleted. Not properly!
I believe subscriptions were deleted, then Agent jobs, then most importantly *Distribution db was dropped*. Replication was set up on a test copy of db. There is nothing going on in the db. So growing log is not an issue.
Problem is that when I right click on Replication option in SQL Server, "Configure Distribution" option doesn't even come up. So, I can't set up a new replication on this server.
What are my options? Is there a way to delete this replication manually?
View Complete Post