Can a merge subscription be re-initialized from the publisher?

Question

We are using SQL merge replication.  Our publisher is a SQL 2008 Enterprise Server.  The subscribers are SQL CE databases.  i know we can mark all subscriptions for re-initialization from the publisher, but I believe the only way to re-initialize one particular subscriber is from the subscriber itself.  Is this true?

Thanks.

---

Clint

Answer 1

You can init a subscriber at the subscription level, that is a single subscriber can be initialized and not all.

This can be done from the UI of SSMS; go to replication folder, expand the publication folder and write click the required sub and you will get the reinitialize option from the menu. It can also be done from the Replication Monitor application.

---

Yaniv Etrogi
site | blog | linked in | mail
Please click the Mark as Answer button if a post solves your problem! or Vote As Helpful

Answer 2

I don't see a way to re-initialize one specific subscriber from Replication monitor in merge replication.  Can you be more specific?

---

Clint

Answer 3

Hi,

I Guess you can Reinitialize under publication's folder. rite click and say Reinitialize.

 

Regards

JakDBA.

 

---

Regards Jak

Answer 4

In Replication Monitor, drill down on your publication, and then click on your subscription on the left hand pane. Then in the right hand pane, right click on the merge replication agent, and select Reinitialize Subscription.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 5

This is not possible.  When I drill down on the publication, then I see the subscriptions (we have about 10) in the right-hand pane, and there is no option to reinitialize them individually.  I can click "view details" on each one of them, but there is no option to reinitialize them individually.

---

Clint

Answer 6

What happens when you view details or double-click the subscription in Replication Monitor, is there an option to re-initialize from the Action menu item?

---

Brandon Williams (blog | twitter)

Answer 7

Sorry for the delay in answering.  I do not have that option.  All I have is this:

---

Clint

Answer 8

How are you replicating your data - push, pull, rmo, SQLCE replication?

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 9

We are using SQL merge replication.  Our publisher is a SQL 2008 Enterprise Server.  The subscribers are SQL CE databases.  i know we can mark all subscriptions for re-initialization from the publisher, but I believe the only way to re-initialize one particular subscriber is from the subscriber itself.  Is this true?

Clint — after taking a closer look, I believe you are correct.  It appears as if SQL CE subscribers can only be reinitialized individually from the subscriber itself using the Synchronize Subscription dialog.  There doesn't appear to be a way to reinitialize individual SQL CE subscriptions from the publisher, only all subscriptions.

---

Brandon Williams (blog | twitter)

Answer 10

Clint — I'm able to reinitialize individual SQL CE subscribers from the publisher by doing the following:

Identify the subscriber you'd like to reinitialize.  Execute this at the publisher:

--Get subscriber and database name to reinitialize
SELECT 
	subscriber_server,
	db_name 
FROM dbo.sysmergesubscriptions

Call sp_reinitmergesubscription at the publisher to reinitialize a specific SQL CE subscriber:

sp_reinitmergesubscription
	@publication = 'TestCEPub',
	@subscriber = 'CESubscription1 - 4ba904ce4f89',
	@subscriber_db = 'C:\Users\brandon\Documents\CEsubDB.sdf'

On the next synchronization the SQL CE subscriber will reinitialize.

---

Brandon Williams (blog | twitter)