Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Drop merge repliaction the right way Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 5:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 6:05 AM
Points: 16, Visits: 291
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.

Post #1392402
Posted Tuesday, December 4, 2012 6:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
Hi,

Please refer to the below:

http://social.msdn.microsoft.com/Forums/is/sqlreplication/thread/62adf53b-6506-4df4-b914-2ff299c0adf5
Post #1392421
Posted Tuesday, December 4, 2012 6:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 6:05 AM
Points: 16, Visits: 291
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....


Post #1392443
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse