Post reply

causes for subscription expiration

  • March 24, 2010 at 6:06 am

    #386571

    Hi,

    the problem is an expired subscription.

    I have a sql-server 2008 publisher/distributor and a sql-server 2000 SP 4 subscriber.

    The retention period is 14days.

    Subscription Validation (rowcount) failed - maybe more than 14days.

    The Merge-Agent ran last yesterday, with Subscription Validation (rowcount) failed, and today the replicationmonitor tells me, that the Subscription is expired. So me question is:

    Can failed supscription validation cause subscription expiration?

    thanks in advance

    peter

  • March 24, 2010 at 6:17 am

    #1138828

    Yes.

    Check here... http://msdn.microsoft.com/en-us/library/ms151188.aspx

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • March 24, 2010 at 6:42 am

    #1138853

    Thanks for fast reply,

    so "...synchronized within 14 days..." means

    "synchronized within 14 days without validation errors"?

    peter

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply