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 ?