Transaction Log Shipping Status Report

All Replies

• Thursday, December 06, 2012 5:34 PM

  Moderator

   

   
  

  1

  Does this apply?

  Transaction Log Shipping Status Report for monitor server will not pull up information if alias is used for monitor server

  ---

  Brandon Williams (blog | linkedin)

  • Reply
  • Quote

   
• Thursday, December 06, 2012 5:45 PM

   

   
  

  1
  Since you did not mention the SQL Server version, I assume it is SQL Server 2005. There is a hotfix available for this issue and check if applying it helps fix the same.

  ---

  
  
  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @PradeepAdiga
  
  

  • Proposed As Answer by Shahfaisal Muhammed Saturday, December 08, 2012 2:11 PM
  • Marked As Answer by Allen Li - MSFTModerator Thursday, December 13, 2012 1:29 AM
  •  
  • Reply
  • Quote

   
• Friday, December 07, 2012 7:34 AM

  Moderator

   

   
  

  0

  Hi ChitraSaha,

  We can use execute sp_help_log_shipping_monitor_primary on primary server and execute sp_help_log_shipping_monitor_secondary on secondary server to get the “Last Copied File” and “Last Restored File” data. For more detail information, please refer to the following link:

  sp_help_log_shipping_monitor_primary (Transact-SQL):
  http://msdn.microsoft.com/en-us/library/ms189441.aspx

  sp_help_log_shipping_monitor_secondary (Transact-SQL):
  http://msdn.microsoft.com/en-us/library/ms177639.aspx

  ---

  Allen Li
  TechNet Community Support

  

  • Proposed As Answer by Shahfaisal Muhammed Saturday, December 08, 2012 2:11 PM
  • Marked As Answer by Allen Li - MSFTModerator Thursday, December 13, 2012 1:27 AM
  •  
  • Reply
  • Quote

   
• Friday, December 07, 2012 2:01 PM

   

   
  

  0
  Are you checking on the primary or secondary. I do not see the last Copied File and Last Restored File in the Transactional Log shipping report on primary, but I see it on Secondary.
  • Reply
  • Quote