Monday, March 19, 2012

Decrising Subscription Expiry Date

Hi to all
I have a merge replication in SQL 2005 spk1 with 54 Subscribers that
are actually Mobile devices.
I set the Expiration date to 30 days and now I want to Reduce it lets
say to 10 or to 8 days.
My Question is this.
Will I get faster Synchs if I do that?
And
By just changing the number of days from 30 to 10 will the subscribers
need to Reinitialize in order to
get this change?
Thanks a lot
Savvas Christodoulou
IIRC for handhelds you will need to reinitialize. Your syncs should be
faster.
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
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1173863832.116924.228550@.n76g2000hsh.googlegr oups.com...
> Hi to all
> I have a merge replication in SQL 2005 spk1 with 54 Subscribers that
> are actually Mobile devices.
> I set the Expiration date to 30 days and now I want to Reduce it lets
> say to 10 or to 8 days.
> My Question is this.
> Will I get faster Synchs if I do that?
> And
> By just changing the number of days from 30 to 10 will the subscribers
> need to Reinitialize in order to
> get this change?
>
> Thanks a lot
> Savvas Christodoulou
>
|||Thank you very mutch for your Overall help in Megre Replication

No comments:

Post a Comment