December 4, 2012 at 5:56 am
Hi
i am about to drop a merge replication and rebuild it with new snapshot and DB.
Replication Server A - B Using Merge repliaction update every 3' min.
It's not working, rather then trying to find the error we diecdecidedrop it since it doesent work anyway.
How do i do this the "right" way?
Do i need to run some cleanup scripts or do..
1. Alltasks at publisher - Delete subscription
2. Alltasks at publisher - Delete publication
3. Drop database at subscription server
4. Create new publication and snapshot
5. Create new Subscription
Is this enough? or am i missing something?
Database is large ~200Gb so it will take some time.
December 4, 2012 at 6:28 am
Hi,
Please refer to the below:
December 4, 2012 at 6:45 am
Thx, this should be the right way since i only have one subscriber i dont have anything to worry about.
And even if i have more subscribers as long as i don't, in thoose cases do this on the Publisher
However in this case i will do it on Subscriber and after that i will do it on Publisher
(I only have one subscriber)
exec sp_removedbreplication 'databasename'
exec sp_replicationdboption 'databasename','merge publish','false'
When this is done i will recreate the replication
it's allways a bit nervous when it comes to production enviroments...
Don't wanna mess upp a big prod database...and i dont wan't errors due to delete the wrong way.
I guess they have done it wrong before thats why i have this problem now...
Sry for any bad english....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply