Setting Up Log Shipping

In order to use log shipping for a high availability solution, you should plan on having at least three separate servers available. One server is the “source” SQL Server from which you will identify a database to log ship from. Another server will be the “destination” SQL Server that is the target of the log shipping and will be your secondary server for fail-over. And finally, the third server will be the “monitor” SQL Server that keeps track of the log shipping tasks and timeliness. We are assuming that you are using the FULL recovery model (or BULK-LOGGED) for database backup, since this creates transactions in the transaction log that will be the source of log shipping. If you choose the SIMPLE recovery model, there ...

Get Microsoft® SQL Server High Availability now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.