Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
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.
Correct Answer: A,B
Explanation/Reference: 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-report-sql-server- management-studio?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transact-sql