SQL Mirroring – Manual Failover

The following steps show a quick description of the process of installing the product with a standby system using SQL mirroring:

  1. Install and configure the product on the primary environment - the database would be mirrored to the standby environment. Use the SQL alias in the product configuration to the SQL box. Also install the SharePoint components.
  2. Stop the product services on primary environment.
  3. Fail-over the mirror to the standby environment.
  4. Adjust the load balanced URL to point to the standby environment.
  5. Install the product on the standby environment ensuring that the SQL alias is used and the NLB address is used.
  6. Disable Nintex K2 services on the standby environment.
  7. Adjust the load balanced URL to the primary environment again.
  8. Failover the SQL database mirror to the primary environment again.

    This image shows the Operating mode set to "Synchronous", but that does not imply the product requires it or even recommends it. For more information see the Types and Operating Modes in Mirroring article online.
  9. Start the services on the primary environment and check the log files to be sure no errors were encountered.