June 28, 2012 at 1:25 pm
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--ServerY-8 failed. The process could not access database on server 'ServerY
Basicallydatabase 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?
June 28, 2012 at 2:45 pm
I got this cleaned up by going in through Management studio and DISABLING Replication - this seemed to cleanup what I messed up and allowed me to re-do the whole thing.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply