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?
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
"Crash" <sourcenexus@.san.rr.com> wrote in message
news:1175191098.139401.217150@.p77g2000hsh.googlegr oups.com...
> 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?
>
|||On Mar 29, 10:08 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> They are purged as they fall out of the conflict retention and merge
> metadata retention windows.
>
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.
|||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
"Crash" <sourcenexus@.san.rr.com> wrote in message
news:1175193126.263827.280740@.y66g2000hsf.googlegr oups.com...
> On Mar 29, 10:08 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> 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.
>
>
Monday, March 12, 2012
Expiring and Reinitializing Subscriptions
Labels:
database,
expiring,
expresstablet,
microsoft,
mysql,
oracle,
publisher,
reinitializing,
retention,
server,
sp1subscribersql,
sp2if,
sp4sql2005,
sql,
subscriber,
subscription,
subscriptions,
windows
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment