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:
- 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:
- 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.
I have run the
RESTORE VERIFYONLY command after backup completes. This command ensures ...