I have this situation where we have replication setup between 2 servers. This is Transactional replication. Now there's a requirement to add another subscription.
Now my question is do I have to break the existing replication and configure it all again or can I simply add another subscription and it should work fine? We have subscription and distribution setup on 1 server which is kinnda readonly server and Publication setup on a production box. Its pull subscription.
Any help would be appreciated.