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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
