O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Prerequisites for Log Shipping

Let's quickly go through the prerequisites for Log Shipping. They are as follows:

  • Recovery model: We should make sure that the database on which we need to enable Log Shipping should be in either a Full or Bulk-Logged recovery model. Here is a table that will brief us about different recovery models and the type of recovery they can provide:

    Recovery model

    Benefit

    Loss of data

    Type of recovery

    Simple

    Keeps T-Log in small size, can perform bulk copy operation

    If needed, we have to restore Full backup or Differential backup

    Possible till the last backup time

    Bulk-Logged

    Minimal log space occupation, can perform bulk operation

    If the log is damaged or bulk operation is done after last T-Log backup

    Can be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required