JarJar (7/30/2014)

---

??? how to setup ???

Technet: How to enable log shipping (TSQL)

---

To enable log shipping

2.On the primary server, execute sp_add_log_shipping_primary_database to add a primary database. The stored procedure returns the backup job ID and primary ID.

3.On the primary server, execute sp_add_jobschedule to add a schedule for the backup job.

4.On the monitor server, execute sp_add_log_shipping_alert_job to add the alert job.

5.On the primary server, enable the backup job.