I configured logshipping how to know the Backup file is restored or not?

If the restore job completes successfully you can conclude that the backup file has been restored. If not, the backup file will not be applied to the secondary server Pradeep Adiga My blog: http://www.sqldbadiaries.com

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