March 2, 2009 at 9:57 am
Right now my db is replicating from Sql Server 2000 to Sql Server 2005.
When I take the production 2000 db over to a new Sql 2005 server, I am going to run sp_repldone on the replicating db, drop subscriptions from the existing 2005 server that is being replicated to, and drop publications from the 2000 replicating db that is moving.
Is there anything I should run on the Sql 2000 db that is moving & the Sql 2005 db that is currently being replicated to, to remove all replicated objects? Or just leave it alone & rebuild replication publication on moved db on new Sql 2005 server & new subscription on existing Sql 2005 db (I was planning on creating new publication & subscription anyway, thanx to answers to my last post).....I just want to make sure I am not missing something.
Thanx!
March 3, 2009 at 9:13 am
when you run dropsubscription and droppublication all replication objects should be removed unless there are errors. You you run also droppullsubscription if you are using "pull" subscribers. Please refer to BOL for the correct invocation place on each.
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply