Migrate Database Server Step-by-Step Guide

  • Article

You can install the Microsoft HPC Pack cluster databases on one or more remote servers that are running Microsoft® SQL Server® or Azure SQL databases, instead of installing them on the head node of your cluster. You can also migrate the SQL databases from local to remote server, or from an old server to a new one.

This guide provides step-by-step procedures for database server migration in HPC Pack 2019.

Overview

For HPC Pack 2019, there are 7 databases required for HPC Pack cluster: HPCHAStorage, HPCHAWitness, HPCDiagnostics, HPCManagement, HPCMonitoring, HPCReporting, HPCScheduler. The connection string for HPCHAStorage database is stored in the registry table on the head nodes. And the connection strings for other databases are stored in HPCHAStorage database.

Procedures

    1. Stop all HPC services on all the head nodes
    1. Backup HPC databases and restore in new DB server (Make sure to grant DB permissions to the HPC setup user and the head node machine account)
    1. Modify the 6 DB connection strings in the database HPCHAStorage in the new DB server with the following SQL query (replace the <New_xxxxx_ConnectionString> with correct values):
Update dbo.DataTable set dvalue='<New_HAWitnessDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'HAWitnessDbConnectionString'
Update dbo.DataTable set dvalue='<New_DiagnosticsDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'DiagnosticsDbConnectionString'
Update dbo.DataTable set dvalue='<New_ManagementDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'ManagementDbConnectionString'
Update dbo.DataTable set dvalue='<New_MonitoringDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'MonitoringDbConnectionString'
Update dbo.DataTable set dvalue='<New_ReportingDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'ReportingDbConnectionString'
Update dbo.DataTable set dvalue='<New_SchedulerDatabase_ConnectionString>' where dpath = 'HKEY_LOCAL_MACHINE\Software\Microsoft\HPC\Security' and dkey = 'SchedulerDbConnectionString'
    1. Modify the registry value HAStorageDbConnectionString under HKLM:\Software\Microsoft\HPC\Security with the new connection string of the HPCHAStorage database on the head nodes.
    1. Restart all HPC services on all the head nodes

See also