how to monitor logshipping? please give me all possible ways?

Hi Jilan, Best way is configure log shipping monitor server and configure your E-Mail account so that you will get alerts for the following primary db and secondary db is not in sync copy/bkp/restore job failed copy/bkp/restore does not happend from last 30 min and so... have a look at below articles to learn how to configure log shipping monitoring. http://msdn.microsoft.com/en-us/library/ms190224.aspx http://msdn.microsoft.com/en-us/library/ms181195.aspx Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

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