unexpected "Agent message code 21074" on trasactional replication RRS feed

  • Question

  • Hello,

    i use a transactional replication to load my datawarehouse DB everynight.

    This works fine for the first repliaction but on the second i get the error "Agent message code 21074 the subscriptions need to be reinitialized..." and i have to reinitialize with new snapshots.

    I can't see why this happen.

    Somebody got an idee ?

    Thanks for your help and best regards

    Friday, March 9, 2007 8:50 AM

All replies

  • 21074 means your subscription has been marked as inactive so it has to be reinitialized. You can check status column in MSsubscriptions table at distribution database to make sure.

    You can take a look at BOL topic "Subscription Expiration and Deactivation" for more info about inactive subscriptions.


    Friday, March 9, 2007 5:42 PM