SQL Cluster

Written By Robert Thomas

Last updated 3 months ago

SQL Cluster

If you plan to use an SQL cluster, it is recommended to install MEDIAL using a local copy of SQL Express. After this,  you can migrate the database to the cluster. When installing MEDIAL for use with a cluster, ensure that the account has rights to create, access, and modify the VLS database.

Back up Databases

  1. Log into SQL Management Studio with an account that has full permission to access and back up the VLS database.

  2. Expand the server node. Expand Databases and right-click on the VLS database to select Tasks > Back Up.

  3. For Destination, select Disk in the drop-down and add the path for the backup of the database followed by VLS.bak.

  4. On the left-hand menu click Media Options and check the Verify backup when finished box. Click OK to perform the backup.

Migrate Databases

  1. Import the VLS database by logging into SQL Management Studio on the cluster and creating a new VLS database.

  2. Call the database VLS and then click OK to create it.

  3. Once the database has been created, right-click it and then select Tasks > Restore > Database.

  4. Select the From device radio button and click the ellipsis on the right.

  5. Click Add in the Specify Backup window.

  6. Browse to the backup of the VLS database and select it. Click OK.

  7. Click OK when you are returned to the Select backup devices window.

  8. Check the box for the source database in the Restore column and then click Options (this should be checked by default).

  9. In Restore Options, choose Overwrite the existing database (WITH REPLACE). Click OK.

Change the Connection Strings

To enable MEDIAL to use the database on the cluster, you must change the connection strings in the web.config files to refer to the new database location. There are four web.config files that need to be changed:

  • vls

  • upload (web.config)

  • vlsservice (vlsservice.config)

  • encoder (encoder.config).

To change the connection strings:

  1. On the MEDIAL server, locate and open the MEDIAL installation folder.

  2. Starting with the encoder folder, open the file called encoder.config.

  3. Locate the connection string in the connectionString XML element and change it so that it points to the database on the cluster. The account will also need to be changed to the one that is going to be used for MEDIAL on the cluster.

  4. Repeat this process for the remaining configuration files in the vls, upload, and vlsservice folders.