Groups | Blog | Home
all groups > sql server replication > march 2007 >

sql server replication : Expiring and Reinitializing Subscriptions


Crash
3/29/2007 10:58:18 AM
Publisher: Windows 2000 SP4
SQL2005 SP1

Subscriber:SQL Server Express
Tablet XP SP2

If I have a subscription retention of 20 days and a subscriber never
misses a 20 day window; aka they never "expire" because they always
replicate within the retention period, what happens to the replication
meta-data? Is the meta-data ever cleaned up in this case or does it
grow and grow because the subscription never exceeded the retention
window?

Also, If I have no expiration for my subscribers - not recommended I
know - is there any way to purge the history? Would reinitializing
the subscription clean things up -or- because there was no expiration,
would it keeps everything and grow, grow, grow regardless of a
reinitialize?
Crash
3/29/2007 11:32:06 AM
[quoted text, click to view]

Don't quite understand your statement.

Yes/No: If subscription is never expired then because I have a 20 day
retention my history will never grow beyond such as appropriate for a
20 day retention.

True/False: If I have no expiration then history will never stop
growing even if I reinitialize a subscription.


Hilary Cotter
3/29/2007 2:08:17 PM
They are purged as they fall out of the conflict retention and merge
metadata retention windows.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Hilary Cotter
3/30/2007 12:00:00 AM
If you have a defined retention period metadata is cleaned up. The metadata
which is cleaned up is metadata which is older than the retention period.

So to answer your first question - Yes. If your subscription has not expired
the metadata will only be retained for whatever your retention period is -
20 days.

For subscriptions with no expiration the metadata is never cleaned up. If
you re-initialized all the existing metadata is purged and replaced with a
new set of metadata. So to answer your second question: False.

Please refer to http://msdn2.microsoft.com/en-us/library/ms151778.aspx for
more information.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button