Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Resources
Spok

Step 4 - Enabling Common Redundant Mirroring Setup on SQL Server

Enabling common redundant mirroring setup on a SQL server is step 4 in the process of configuring SQL Server redundant mirroring sessions.
  1. Connect to the Principal server.

  2. Run the contents of Mirroring\Common\1-Mirroring - PRINCIPALDB.sql.

  3. Connect to the Mirror server.

  4. Run the contents of Mirroring\Common\ 2-Mirroring - MIRRORDB.sql.

  5. Connect to the Witness server.

  6. Run the contents of Mirroring\Common\3-Mirroring - WITNESSDB.sql.

  7. From the Principal server, copy the file located in C:\principal_certificate.cer to the C:\ directory on the Mirror server.

  8. From the Principal server, copy the file located in C:\principal_certificate.cer to the C:\ directory on the Witness Server.

  9. If the SQL Server Version supports Transparent Database Encryption, the “1-Mirroring - PRINCIPALDB.sql” script run produces the AmcomCert.cer file. If the file exists, copy the AmcomCert.cer file from the Principal server onto the Mirror and Witness server’s C:\ drive.

  10. Copy the AmcomCert.pvk file from the Principal server onto the Mirror server’s C:\ drive.

  11. Copy the AmcomCert.pvk file from the Principal server onto the Witness server’s C:\ drive.
    NOTE: The AmcomCert.pvk file also gets produced by “1-Mirroring - PRINCIPALDB.sql”

  12. From the Mirror server, copy the file located in C:\mirror_certificate.cer to the C:\ directory on the Principal server.

  13. From the Mirror server, copy the file located in C:\mirror_certificate.cer to the C:\ directory on the Witness server.

  14. From the Witness server, copy the file located in C:\witness_certificate.cer to the C:\ directory on the Principal server.

  15. From the Witness server, copy the file located in C:\witness_certificate.cer to the C:\ directory on the Mirror server.

  16. On the Principal server, run the contents of Mirroring\Common\4-Mirroring - PRINCIPALDB.sql.

  17. On the Mirror server, run the contents of Mirroring\Common\5-Mirroring - MIRRORDB.sql.

  18. On the Witness server, run the contents of Mirroring\Common\6-Mirroring - WITNESSDB.sql. SQL Server has been configured to use certificate-based authentication and TCP to mirror databases. For detailed information on how to set up each Spok database to use the mirroring configuration, refer to Enabling Each Spok Database for Redundant Mirroring on SQL Server.