Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Generate Scripts... Expand / Collapse
Posted Monday, January 31, 2011 11:36 AM


Group: General Forum Members
Last Login: Wednesday, August 31, 2016 12:49 PM
Points: 115, Visits: 390
I'm pretty new to Replication, so please excuse the newbie sort of approach. We have a development database ICC4, and there is a publication set up to copy tables from ICC4 to the CentralData DB. It is a transactional publication, and CentralData exists on multiple servers.

We have a nightly overlay, where ICC4 is copied from production over to the development server. From what I read, we were supposed to basically delete the subscriptions and publication, overlay the database and recreate the publication and subscriptions afterward.

I used the Generate Scripts method to delete before, and create afterward, but ran into trouble. There still appear to be orphaned publisher records and the code below kept failing (so I commented it out). This made sense since the qreader was never deleted in the earlier code.

--exec [EPC].sys.sp_addqreader_agent @job_login = null, @job_password = null, @frompublisher = 1

We've disabled the publication while we try to figure this out, but I see references to ICC4 in multiple distribution tables. So my questions are:

Is there a better/cleaner way to stop or disable replication while a database is overlayed and then continue it up afterward?

How do I remove the orphaned records that our monitoring system keeps telling us about, with the message: "Replication-Replication Transaction-Log Reader Subsystem: agent _____-ICC4-7 failed. The process could not execute 'sp_repldone/sp_replcounters' on '________'."

I appreciate any insight you guys can provide. Thanks.
Post #1056337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse