Enabling MS-SQL Server Mirroring

Note: Since Microsoft plans on removing database mirroring from future versions of SQL Server, it is recommended to use Always On availability groups instead. For more information, see Setting Up Always On Availability Groups and Configuring ActivID CMS to Use Always On Availability Groups.
Prerequisites: To enable the mirroring solution:

  • Three servers (Principal, Mirror, and Witness) using Microsoft SQL Server.

  • ActivID CMS must be installed according to the information provided in Configuring ActivID CMS to Use Database Mirroring. This means the system must be configured to have Principal and Mirror database servers set up, even if the ActivID CMS databases are not installed on the Mirror server.

  • All servers must be members of the same domain.

This section describes the procedures for the following operations:

  • Starting up MS-SQL server services and updating hosts,

  • Setting up the recovery model,

  • Creating databases on the Mirror server,

  • Backing up the ActivID CMS databases on the Principal server,

  • Restoring the ActivID CMS databases on the Mirror server,

  • Enabling mirroring, and

  • Transferring logins and passwords from the Principal server to the Mirror server.

Note: This section was written for SQL Server 2008; the same concept applies to SQL Server 2012 and higher; instructions may need to be adjusted for the version you are deploying.

Topics in this section: