Constraint Violating Yak Guru
Posted - 06/28/2012 : 15:27:29
| I am running
Microsoft SQL Server 2005 - 9.00.4226.00 (X64) SQL Server 2005 Standard
I had a working transactional replication publication set up and it was working. I needed to restore the database that was acting as publisher and then change who the subscriber was so what I did was drop the subscription, drop the publication, restored the database (to a new name) and then rebuilt the publication and added the new subscriber.
I must have done something out of order because I created the new publication and then added the new subscriber and I cannot get it to work.
These are the type of errors I am getting in the log:
(note Server names have been changed to Serverx (Publisher) and ServerY (Suscriber))
Replication-Replication Transaction-Log Reader Subsystem: agent Serverx-CM-1 failed. The process could not execute 'sp_repldone/sp_replcounters' on 'Serverx'.
Replication-Replication Distribution Subsystem: agent Serverx-CM-CM-ServerY-8 failed. The process could not access database 'CM_Test' on server 'ServerY
Basically CM_TEST database is the OLD original subscriber and that database has been dropped.
I tried recreating it and that didn't help
now I am just attempting to drop the new publication that I created and it hangs and then crashes Management studio.
Not really sure where to go from here.. can anyone help?