December 28, 2010 at 12:39 am
Hi guys, my name is Ryan, I have some issues with replication monitor.
I have a database, let's just called ALL_DATA_DB and it was enabled for replication. In one time I made a snapshot publication in that database to another server and it was successfully made, and well running. And in a couple of days ago, I have to remove that publication on that database. I use sp_removedbreplication 'ALL_DATA_DB' store procedure command and it was successfully removed, I checked in the Replication >> Local Publication folder in the SQL Management studio the publication was gone and no longer exists so that means the snapshot publication was removed. So after I remove the snapshot publication that I made before, I create a new publication with some differences than the first one. The newly made publication was created successfully and working well also. The problem is when I check in the replication monitor the old snapshot publication still exists, why ? so I went to the Job Activity monitor in the SQL management studio, the job that hold the old snapshot publication still exists, so I delete the job hoping that it will remove the old ones in the replication monitor also, but it didn't. What cause the problem and how can I remove it from the replication monitor and can it cause more trouble to my database server or to the subscription database server? can you guys help me please, sorry If this too long to read, i just want to be clear bout the problem that I've gone through.
Thanks in advance 😀 ,
Ryan
February 10, 2011 at 8:59 am
Hi,
I had a similar issue until about ten minutes ago.
Why it happens i dont know... but read the following post on how to fix it - http://www.sqlservercentral.com/Forums/Topic125951-7-2.aspx
In SUmmary, you need to create the publication again with the same publication name and against the same publication DB and then remove it.
It has to do with some sort of incomplete cleanup.
February 17, 2011 at 8:44 am
In 2005 management studio there was a bug where monitor could do some really 'interesting' stuff (in our case it would invalidate the subscription) what you are seeing might be related to this.
http://support.microsoft.com/kb/967192
Not quite the same but worth a look IMHO
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply