Log Shipping Status Report - Columns Empty

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  August 22, 2007 at 12:32 pm

  #121254

  quite a few columns are empty in the log shipping status report that I am looking at. I am unable to tell when was the last copy and restore.

  Why is this happening? what table can I query to get this info?

  thanks

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  August 23, 2007 at 3:36 am

  #728830

  I think you can get the info from the below system trables,

  http://msdn2.microsoft.com/en-us/library/ms190355.aspx  but if you have a log shipping monitor configured it will store the info of which was the last backup copied,restored etc..........

  [font="Verdana"]- Deepak[/font]