Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"Transaction Log Shipping Status" not updating

18 views
Skip to first unread message

geek-y-guy

unread,
May 24, 2010, 6:51:30 AM5/24/10
to

Hi All: I have two 2005 servers, with the primary shipping logs to the
secondary. At some point several weeks ago there were problems on the
primary server (ran out of space for the transaction log dumps) and the
secondary went out of sync. I ended up disabling all the shipping jobs on
both servers, performed a new restore of the primary dB on the secondary
server, and then re-started all the shipping jobs.

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!

0 new messages