• I am too testing Transactional Replication Backup / Restore. What are the other options?

    Scenario 1:

    My publisher DB is running but for some reason i need to restore.

    In this scenario, i can drop the subscriber, drop the publication,

    Restore the Publisher from backup (Delete extra loaded rows from subscriber)

    => Create new publication , Create new subscription

    Scenario 2:

    My publisher DB crashed:

    In this case i don't think it is possible to drop the subscription/publication.

    Hence restore the publication db keeping the replication (The subscriber would

    be out of sync with publication at this stage). Hopefully it should allow me to

    drop the subscription followed by dropping of the publication , delete the

    redundant data at the Subscribe DB and then create pub/subscription.

    Hopefully this should work.

    Feel free to correct me.