- City A - Primary server for logshipping
- City B - Secondary server for logshipping
Now there is a lot of data being updated from A - B.
And the server in City B is underutilized, and it is a very powerful machine.
Can I install a Reporting server and a mirroring server on the server which hosts the secondary logshipping server, and run the Reporting and mirroring server to get the data from the sSecondary logshipping server?
We cannot have the data come across 3 times (one for Logs, Report, Mirror) - and the secondary server is updated regularly enough to allow for our requirements.
But the secondary logshipping server is obviously always in Standby/Readonly mode - is this all possible?