August 27, 2009 at 12:58 am
Hi,
I would like to know in detail about the Subscription Expiration option in Replication using SQL Server 2005.
I need to know the difference between the option
"Subscriptions never expire but they can be deactivated until they are reinitialized"
and the option
"Subscription expires and may be droped if not synchronized within the specified period"
which of these options have to be used in a production, what happens if we choose the option
"Subscription expires and may be droped if not synchronized within the specified period"
Will the subscription created for the subscriber db will be droped and recreated if not in synchronization or only the articles or the metadata in the distribution database will be removed and recreated, please let me know.
an few more details about the same.
With Regards
Dakshina Murthy
August 27, 2009 at 2:02 pm
Here is BOL:
"Subscriptions expire and are dropped if not synchronized in the following number of hours/days
Set the number of hours for snapshot and transactional publication, or the number of days for merge publications. This is the number of hours or days in which synchronization needs to occur, otherwise the subscription will be dropped.
Subscriptions never expire
Allows subscriptions to exist even if they haven't synchronized. For snapshot and transactional publications, the subscription will be deactivated until it is reinitialized."
also some good info at
http://msdn.microsoft.com/en-us/library/ms151188(SQL.90).aspx
HTH.
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
August 27, 2009 at 9:05 pm
Hi,
Thanks a lot for the input, i will definitely go through the links, if any i will get back to you, please help me out.
With Regards
Dakshina Murthy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply