Explanation:sp_add_log_shipping_secondary_primary sets up the primary information, adds local and remote monitor links, and creates copy and restore jobs on the secondary server for the specified primary database. 9. Which of the following table stores history detail for log shipping jobs ?
A. log_shipping_monitor_alert
B. log_shipping_monitor_primary
C. log_shipping_monitor_history_detail
D. None of the mentioned
Answer:A
Explanation:sp_add_log_shipping_secondary_primary sets up the primary information, adds local and remote monitor links, and creates copy and restore jobs on the secondary server for the specified primary database. 9. Which of the following table stores history detail for log shipping jobs ?
A. log_shipping_monitor_alert B. log_shipping_monitor_primary C. log_shipping_monitor_history_detail D. None of the mentioned
Explanation:log_shipping_monitor_alert stores alert job ID. 10. _____________ maps primary databases to secondary databases in log shipping.