Post reply

Sqlserver replication error

  • October 23, 2012 at 5:56 am

    #268995

    Hello Team,

    How to solve below error and may i know the reason why it happens

    The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)

    Thanks in advance

  • October 23, 2012 at 11:44 pm

    #1552137

    The subscriber is out of sync for more than transaction retention period( default 72 hours). This is the reason for marking subscriber inactive. You have to reinitilize the subscription to sync with. You can check the transaction retention period by right click on replication folder and select 'Distributor properties' and can see transaction retention period values.

    Thanks

    Jo

  • October 24, 2012 at 1:36 am

    #1552150

    Thanks Jo

  • October 24, 2012 at 2:49 am

    #1552169

    Thanks Jo you want me to change any settings in distribution properties.

  • October 24, 2012 at 7:51 am

    #1552279

    No.. it is completely based on your requirement. For example if your subscriber is going to be down for more than 72 hours then you can change this value. But important thing is the distributor database has to store the transactions upto that long hours, then the distribution DB size will increase. My suggestion is the default value is fine unless it is highly required.

  • October 24, 2012 at 9:47 am

    #1552336

    Got it Jo Thanks alot your help

Viewing 6 posts - 1 through 5 (of 5 total)

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