Thursday, December 06, 2012 4:08 PMWhy do I not see the Last Copied File and Last Restored File in the Transactional Log shipping report? However I do see the Last Backup File in the Log shipping status report.
Thursday, December 06, 2012 5:34 PMModerator
Does this apply?
Thursday, December 06, 2012 5:45 PMSince 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.
Friday, December 07, 2012 7:34 AMModerator
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:
TechNet Community Support
Friday, December 07, 2012 2:01 PMAre 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.