Explanation:Log Shipping is a pretty simple process to setup. 6. Which of the following stored procedure is used to add a primary database on primary server ?
A. sp_add_log_shipping_primary_database
B. sp_add_primary_database
C. sp_add_log_shipping
D. sp_add_log_shipping_primary
Answer:A
Explanation:Log Shipping is a pretty simple process to setup. 6. Which of the following stored procedure is used to add a primary database on primary server ?
A. sp_add_log_shipping_primary_database B. sp_add_primary_database C. sp_add_log_shipping D. sp_add_log_shipping_primary
Explanation: sp_add_log_shipping_primary_database stored procedure returns the backup job ID and primary ID. 7. Execute sp_add_jobschedule to add a schedule for the backup job on _________ server