log shipping related doubt?
configured log shipping . How to find what are the backup files are restored in secondary server? How to find restore job fails?
November 10th, 2010 9:47am

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
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 4:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics