I have a database installed by a 3rd party software and currently marked (suspect) in EM. I need to drop this database but the system will not let me because it is flagged as being replicated even though there is no replication going on this server.
It was marked suspect when the 3rd party software was uninstalled. The problem is even when it was not suspect it was flagged as being replicated (and there for unable to be dropped or disconnected)when there is no replication on the server at all. I need to just kill this and purge it from my server somehow.
What we do to drop a database that is replicated is restore on top of that database with any database that you have that does not have replication. You can then drop it. When you do the restore, make sure to select the same name as the one that you want to drop.