I am having an on-premises sql server db which acts as a publisher to a subscriber (in transactional replication).
After i restore this db through a .bak file (this file has no information about transactional replication setting), my replication settings on server where on-premises sql server db is restore are gone. Under Replication folder, both publication and subscription get deleted, i need to manually set publication/deletion again.
Could you please let me know after restoring the .bak file to on-premises sql server db, how can i retain the transactional replication settings so that it works as earlier without having to do any change on the server.
A working example would be really helpful here.