InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:34:37 GMT20http://www.sqlservercentral.com/Forums/Topic1392402-1549-1.aspxThx, 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 PublisherHowever 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 replicationit'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....Tue, 04 Dec 2012 06:45:09 GMTKnut_knuthttp://www.sqlservercentral.com/Forums/Topic1392402-1549-1.aspxHi,Please refer to the below:http://social.msdn.microsoft.com/Forums/is/sqlreplication/thread/62adf53b-6506-4df4-b914-2ff299c0adf5Tue, 04 Dec 2012 06:28:10 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1392402-1549-1.aspxHi 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 subscription2. Alltasks at publisher - Delete publication3. Drop database at subscription server4. Create new publication and snapshot5. Create new SubscriptionIs this enough? or am i missing something?Database is large ~200Gb so it will take some time.Tue, 04 Dec 2012 05:56:08 GMTKnut_knut