You configure log shipping on two servers named SQL1 and sql2. SQL2 is in Standby mode. You configure backup and restore to occur every hour. A user generates a report from sql2 and discovers that the report data is out-of-date. You verify that the report data is a day old and discover that the primary backup files are available only on SQL1. You need to identify what prevents the primary backup files from being available on sql2.
Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . From SQL2, execute the SP_log_shipping_monitor_secondary system stored procedure.
B . From Microsoft SQL Server Management Studio on SQL1, run the Transaction Log Shipping Status report.
C . From Microsoft SQL Server Management Studio on SQL2, run the Transaction Log Shipping Status report.
D . From SQL1, review the SQL Server Agent job history log.
E . From SQL1, execute the SP_log_shipping_monitor_secondary system stored procedure.
Answer: A,B
Explanation:
A: The history and status of the backup operation are stored at the primary server, and the history and status of the copy and restore operations are stored at the secondary server.
log_shipping_monitor_secondary stores one monitor record for each secondary database, including information about the last backup file and last restored file that is useful for monitoring.
B: The Log Shipping Report displays the status of any log shipping activity whose status is available from the server instance to which you are connected.
References: https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/view-the-log-shipping-reportsql-server-management-studio?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transactsql