I have a existing transactional replication configured and running: one publication on server A and one subscriber on server B. We use the subscriber as reporting server. As the number of reports increased, we see the need for a second reporting server. Here is the question: which of the following configuration do you recommend and why?
Create a new identical publication on server A and a new subscriber on server C.
Use existing publiction on server A and create a new second subscriber on server C.