Can an expired sql server 2005 subscription be re-initialized?

Posted on 2010-03-31
Medium Priority
Last Modified: 2012-05-09
We have 7 sites that use sql 2005 databases (merge) replicating happily to each other with Push subscriptions.

Unknowingly the comms at 1 site had been down for just over 2 weeks and because the default setting on expired subscriptions was not changed from 14 days, 1 site is now expired.

How do I re-subscribe it? We have 1 site as the publisher and all other sites subscribe to the main site.
Question by:alexking
  • 3
  • 2
LVL 17

Expert Comment

ID: 29252782

Author Comment

ID: 29318341
Thanks, useful links, some of which I already came across - since I am only re-initializing 1 site out of 7, if it insists on re-creating the snapshot, will this have any effect on the other subscriptions that I don't want touching? It won't try and re-apply the initial snapshot to the other subscriptions as the data is 6GB and that will not be possible over the broadband?
LVL 17

Accepted Solution

k_murli_krishna earned 2000 total points
ID: 29352397
A single subscription or all subscriptions to a publication are marked for reinitialization.

Upload unsynchronized changes before reinitialization for Merge replication only. Select to upload any pending changes from the subscription database before the data at the Subscriber is overwritten with a snapshot.
If you add, drop, or change a parameterized filter, pending changes at the Subscriber cannot be uploaded to the Publisher during reinitialization. If you want to upload pending changes, synchronize all subscriptions before changing the filter.

According to BOL, Reinitializing a subscription involves applying a new snapshot of one or more articles to one or more Subscribers.transactional and snapshot replication allow individual articles to be reinitialized; merge replication requires all articles to be reinitialized. (But 1 subscription at a time should be okay)

You should be able to reinitialize a specific subscription without affecting other subscriptions. Simply locate the subscription you want to reinitialize in SEM->right-click->reinitialize.. re-generate snapshot and you should be good to go.

Author Comment

ID: 29443572
Thankyou that makes it much clearer - I am running some test this weekend before trying it on the live database :)

It is quite alarming how during the process it appears to have wiped all data from the subscripbing database!

Author Closing Comment

ID: 31709597
Thankyou for your help - it's so hard to find people who can help with replication questions!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Exchange administrators are always vigilant about Exchange crashes and disasters that are possible any time. It is quite essential to identify the symptoms of a possible Exchange issue and be prepared with a proper recovery plan. There are multiple…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question