We have currently pull transaction replication with 1 publisher, 1 distributor and several subscribers. The replication is for several tables only. I want to create new subscriber and this time restore it from backup. All the process and configuration is pretty simple, but I wanted to check if the following will work:
backup the publisher
backup one of the subscriber (right after no.1).
copy subscribers backup (which is much lighter) to the future subscriber and restore
define the new subscriber.
From my tests it is picking data and works ok, but I didn't test it heavily yet. Is this practical?
Thanks in advance