question

chitrarekha.saha avatar image
chitrarekha.saha asked

Transaction Log Shipping Status Report

Why 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.
sql-server-2008-r2
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Blackhawk-17 avatar image
Blackhawk-17 answered
Because you are most likely viewing it from the Primry. If you run the report from the secondary you'll see the opposite. Running the report from a monitor instance should show both sets of data.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.