0

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.

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

0

Your Answer

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

Browse other questions tagged or ask your own question.