Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sqlserver replication error Expand / Collapse
Author
Message
Posted Tuesday, October 23, 2012 5:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 2, 2013 8:05 PM
Points: 43, Visits: 254
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
Post #1375987
Posted Tuesday, October 23, 2012 11:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
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
Post #1376328
Posted Wednesday, October 24, 2012 1:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 2, 2013 8:05 PM
Points: 43, Visits: 254
Thanks Jo
Post #1376341
Posted Wednesday, October 24, 2012 2:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 2, 2013 8:05 PM
Points: 43, Visits: 254
Thanks Jo you want me to change any settings in distribution properties.
Post #1376361
Posted Wednesday, October 24, 2012 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
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.
Post #1376490
Posted Wednesday, October 24, 2012 9:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 2, 2013 8:05 PM
Points: 43, Visits: 254
Got it Jo Thanks alot your help
Post #1376559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse