I would like to know, is it possible to initialize transactional replication from database snapshot spare file for existing replication which is inactive and expired default more than 72 hours.

I have a SQL 2014 which is replicating to SQL 2019 & 2014 as well. it is big database and table. I cannot do initialize from backup since the existing subscriber having other objects as well.

Can anyone have steps or scripts to initialize transactional replication from database snapshot. That would be helpful.

  • I don't believe this is possible, unfortunately.
    – J.D.
    Nov 11 at 14:21
  • 1
    Thanks JD for the update. Nov 13 at 17:08


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.