Logshipping Monitor not getting updated

• csesaravana

  SSC Enthusiast

  Points: 179

  More actions

  December 8, 2009 at 2:43 am

  #213288

  Hi Guys ,

  I have a strange problem here ,

  I have a logshipping configured between a Primary and a DR Server .

  Though the Logshipping monitor shows as failure, but my Copy , restore job is running successfully and the Data is in sync .

  To remidate this issue , I can truncate the below tables to fix the issue ?

  select * from dbo.log_shipping_primaries

  select * from dbo.log_shipping_secondaries

  select * from dbo.log_shipping_plan_databases

  select * from dbo.log_shipping_plans

  If i truncate , will this impact by loghipping ?. Is there is any other solution available ?.

  Looking forward to your response .

  Thanks and Regards,

  Saran

• SQLbee

  Ten Centuries

  Points: 1009

  More actions

  December 10, 2009 at 2:28 am

  #1090415

  You should not be attempting to truncate any of the tables mentioned below.

  Do you have an alert server setup with the primary and secondary.

  User the query below on your primary server

  use msdb

  select * from log_shipping_monitor_primary

  User the query below on your secondary server

  use msdb

  select * from log_shipping_monitor_secondary

  These will tell you if the data is in sync for sure.

  Regards

  Akhil