September 15, 2006 at 1:24 am
We have setup about 50 + databases for merge replication. All the replication are set to sync concurrenttly, except one which is setup to concurrent on a weekly basis - Friday. We have used the default expriy of 14 days
Last two weeks, for this database were weekly sync to happen, the data did not got in sync, though there are records pending for synchorinzation. However since the sync did not happen within 14 days, the subcription got dropped on the 14th day.
Had the subscription did not got expried the data would have got sync on the next friday ie today. (today is the 15th day)
My question, eventhough there were data pending in queue for synchronization which could happen on the friday, why the subscription gets dropped. Could not the cleanup process check for this before dropping the subscription. I am sure redmond guys could not have missed this step. Is there any way to we can ensure the subscription does not get deleted due to this (i don't want to setup a higher value ) -pending records for sync.
Need formum members views on this
thanks
rangark.
September 18, 2006 at 8:00 am
This was removed by the editor as SPAM
September 18, 2006 at 1:13 pm
Rangark,
The Redmond guys did not miss a step. The expiration parameter indicates how long to wait for a subscriber to get data before the subscriber is dropped. If it were based on there being any data in the queue, then the subscriber would never be dropped, and the publisher would be stuck keeping track of data changes for ever. Just choose a number that represents a resonable amount of data to keep at the publisher while waiting for a subscriber to successfully download it. We set ours to 45 days, but each application will have its own requirements.
Have Fun!
Ronzo
October 14, 2006 at 8:48 am
The cleanup is done by "expired subscirption cleanup" job, which is not dependent on the rention period. The sp sp_expired_publication_cleanup is deleting the subcription,irrespective of the data is in queue or not
I am planning to disable this job. Any adverse impact due to this disabling?
rangark.
October 14, 2006 at 3:21 pm
No, there is no adverse impact other than never dropping a subscription. It sounds like this is exactly what you want. You are right that there are two dates. We retain 48 hours of data in our queue (distribution database), but we expire subscriptions after 45 days. The real downside to never expiring a subscription is that your distribution database will retain the data until the subscriber picks it up, meaning the distribution database can get very large over time if the subscriber never picks it up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply