Prev: Replication newbie
Next: Latency Threshold Alert Not Working
From: geek-y-guy on 24 May 2010 06:51

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!

 | 
Pages: 1
Prev: Replication newbie
Next: Latency Threshold Alert Not Working