I setup Log Shipping. I have Secondary Destination Server as Monitoring server also. For some reason when running this system stored procedure or looking at Server–>Reports–>Transaction Log Shipping Status:
EXEC sp_help_log_shipping_monitor
Secondary Destination (also Monitoring): I only see rows for Secondary Destination, do not see any rows for Primary
Primary Server: I see rows for Primary, even though this is not the monitoring server,
My Monitor logins are temporarily SA on both servers, to make sure its not security issue, so not sure why is Primary is not showing on Secondary Monitoring server. Is this the way Log Shipping is supposed to work by functionally ?
Best Answer
Have you configured your log shipping correctly?
I've reproduced the issue on SQL Server 2014. So to fix it, you need to setup the correct connection of your secondary/monitor instances using
SERVERNAME\INSTANCENAME
. Check this link.Once you properly configure log shipping use the follow command below to check the report: