March 27, 2008 at 9:37 am
After needing to rebuild and reconfigure several of the databases used in log shipping, I seem to have lost the functionality of the log shipping monitor. Does anyone know what I can do to get this working again?
March 28, 2008 at 2:04 pm
I assume the log shipping monitor does not get the correct backup dates.
In log_shipping_primaries table, check if the primary_server_name column has the same value as when running SELECT @@SERVERNAME.
Do the same for log_shipping_secondaries table.
_____________
Donn Policarpio
March 31, 2008 at 4:47 am
Yes thats true, the dates in log_shipping_primaries are out of date. It appears like this table is not getting updated.
The servernames listed from @@servername reflects what is in the log_shipping_primaries and log_shipping_secondaries table
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply