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.
On both servers, stop the Genetec™ Watchdog service and the Genetec™
- Select the Genetec™ Watchdog service and click Stop Service on the toolbar at the top of the page.
- Double-click the Genetec™ Watchdog service and set the Startup Type to Manual .
- Select the Genetec Server service and click Stop Service on the toolbar at the top of the page.
- Double-click the Genetec™ Server service and set the Startup Type to Manual.
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.
Open SQL Management Studio and connect to the Security
Center database instance (by default
the instance name is SQLEXPRESS)
Right click on each one of the Security
Center databases and select .
- Open SQL Management Studio and connect to the Security Center database instance (by default the instance name is SQLEXPRESS)
- 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).
- Stop the SQL service on both servers.
Using SQL Server Configuration Manager, modify the SQL startup parameters
for the master database on both servers.
- Open your SQL Server Configuration Manager.
- Select SQL Server Services in the pane on the left.
Right-click on SQL Server (SQLEXPRESS) and select
- Select the Advanced tab in the SQL Server (SQLEXPRESS) Properties window.
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).
- 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).
- Restart SQL service on both servers.
- Reconnect SQL Management studio to SQL server for the active server.
Re-attach the Security
When prompted to point to the database to be attached, use the
Add button to browse to the new path of your (moved) master
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.
- Make sure that all the databases that were previously detached are re-attached.