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

Installing Database Mirroring

In the previous section, we learned about the prerequisites to install Database Mirroring; let's now learn how to install it.

Preparing for Database Mirroring

Before we move forward, we shall prepare the database for the Database Mirroring. Here are the steps:

  1. The first step is to ensure that the database is in Full Recovery mode. You can set the mode to "Full Recovery" using the following code:
    Preparing for Database Mirroring
  2. Execute the backup command, followed by the transaction log backup command, and move the backups to the server we wish to have as a mirror.

    Note

    I have run the RESTORE VERIFYONLY command after backup completes. This command ensures ...

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