Which two actions should you perform?

You configure log shipping on two servers named SQL1 and 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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.