configured log shipping . How to find what are the backup files are restored in secondary server? How to find restore job fails?

Log Shipping Monitor is the tool to use for such a purpose. It will show the backup restored on the destination. How to Check Log Shipping Status: MSDB database tables on secondary store the information. SQL Server 2005 has a capability to provide a report on log shipping status on both primary and secondary servers. Following approach is used to check the log shipping status: Connect to the Secondary Server/Instance from Management Studio Right click on the server name (Primary/Secondary) in the object explorer Navigate to Reports and then to Standard Reports Click on “Transaction Log Shipping Status” Arthur My Blog