September 17, 2007 at 9:03 am
how can I tell if both primary and secondary databases in a log shipping configuration are insync. if they are not insync then how far behind is the secondary?
Is there a script that can help me with that. For some reason in management studio the transaction log shipping report is not showing me that info.
September 18, 2007 at 2:21 am
log_shipping_secondary_databases system table, which can be found in the msdb datbase on the monitoring server it should provide you with the date, time and the name of the last file restored.
Gethyn Elliswww.gethynellis.com
September 18, 2007 at 3:53 pm
If your databases are out of sync you can check the SQL Server log of the monitor server to find out how far out of snyc they are.
September 19, 2007 at 8:25 am
well log_shipping_secondary_databases table in the monitoring sql instance is empty. however when I generate a transaction log status report from primary instance it shows me databases being log shipping but most of the columns are empty.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply