Configuring SQL Server for the cluster - Security Center 5.8

Security Center Installation and Upgrade Guide for NEC Cluster 5.8

series
Security Center 5.8
revised_modified
2020-01-02
category_custom
Guides
Guides > Installation guides
prodname_custom
Security Center unified platform > Security Center
vrm_version
5.8

To configure your SQL database server for a clustered environment, you must move the database to your mirrored data partition so that the contents of the database are identical on the active server and the standby server.

Procedure

  1. On both servers, stop the Genetec™ Watchdog service and the Genetec™ Server service as follows:
    1. Click Start > Control Panel > Administrative Tools > Services
    2. Select the Genetec™ Watchdog service and click Stop Service on the toolbar at the top of the page.
    3. Double-click the Genetec™ Watchdog service and set the Startup Type to Manual .
    4. Select the Genetec Server service and click Stop Service on the toolbar at the top of the page.
    5. Double-click the Genetec™ Server service and set the Startup Type to Manual.
  2. In SQL Management Studio, you will need detach all Security Center databases before the database files can be moved to your mirrored data partition. Detaching a database removes it from the instance of the Microsoft SQL Server but leaves intact the database, with its data files and transaction log files.
    1. Open SQL Management Studio and connect to the Security Center database instance (by default the instance name is SQLEXPRESS)
    2. Right click on each one of the Security Center databases and select Task > Detach.
  3. Move the Security Center *.MDF and *.LDF database files from their default folder (C:/Program Files/Microsoft SQL Server/MSSQL10_50.SQLEXPRESS/MSSQL/DATA) to the SQL folder on the mirror partition created earlier (N:/MSSQL/DATA).
  4. Stop the SQL service on both servers.
  5. Using SQL Server Configuration Manager, modify the SQL startup parameters for the master database on both servers.
    1. Open your SQL Server Configuration Manager.
    2. Select SQL Server Services in the pane on the left.
    3. Right-click on SQL Server (SQLEXPRESS) and select Properties.
    4. Select the Advanced tab in the SQL Server (SQLEXPRESS) Properties window.
    5. Modify the field Startup Parameters to point to the new master database path.

      In this example we have modified the startup parameters to: -dN:/MSSQL/Data/master.mdf;-eN:/MSSQL/Data/Log/ERRORLOG;-lN:/MSSQL/mastlog.ldf, whereby the field points to the new (mirrored) drive and folder path of our master database (N:/MSSQL/Data).

  6. Move the master database (master.mdf and master.ldf) for the active server to the SQL folder on the mirror partition created earlier (N:/MSSQL/DATA). Delete the master database (master.mdf and master.ldf) on the standby server (it will be replicated from the active server).
  7. Restart SQL service on both servers.
  8. Reconnect SQL Management studio to SQL server for the active server.
  9. Re-attach the Security Center databases.
  10. When prompted to point to the database to be attached, use the Add button to browse to the new path of your (moved) master database.
    IMPORTANT: This step needs to be performed on the standby server as well but it is not possible at this point. Once the cluster configuration has been completed, you will need to force a failover to the standby server, then connect SQL Management Studio to its SQL server to re-attach the same databases.
  11. Make sure that all the databases that were previously detached are re-attached.