Exploring the High-Level Steps Involved with Setting Up a Database Mirror

The steps to set up a simple mirror relationship between principal and mirror instance are relatively straightforward. In essence, you just need to back up and restore the databases to the mirror server and configure the server:

  1. Set the transaction level to FULL for all databases that will be mirrored (if not already set).
  2. Perform a full backup of the databases.
  3. Perform a logs backup of the databases.
  4. Restore the full backup onto the mirror server with the NO RECOVERY option.
  5. Restore the logs backup onto the mirror server with NO RECOVERY option.
  6. Configure security between principal and mirror using the wizard. If necessary, configure the witness server.
  7. Enable mirroring ...

Get Microsoft SharePoint 2010 Unleashed 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.

Start your free trial