Everything is OK from a restore point...the shipping and restore jobs are
running within their scheduled intervals, but on the secondary server, the
"Transaction Log Shipping Status" report is not being updated (if I run the
report on the primary, the report is showing the copies/restores OK).
On the secondary, MSDB.log_shipping_monitor_history_detail table is
recording the copies/restores, but the "log_shipping_monitor_secondary"
table shows "null" for the "last_copied_file" and "last_copied_date" fields.
What do I need to do to get this table updating properly?
TIA!