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.