How to move HC Database from one machine to another?

Question: How to move the HC Database or Master Server from one machine to another?

Answer: Following steps should be followed to move the HC database:

HC10 Instructions:
  1. Backup the HC database using SQL Server Management Studio.
  2. Restore the HC database on the new SQL Server using the backup taken in step # 1.
  3. On the new SQL Server, make sure the following settings are specified:
  • SQL Collation
     
     SQL Server Collation must be SQL_Latin1_General_CP1_CI_AS
     
     
      
  • SQL Authentication
    • SQL Server should be configured with a mixed authentication mode, i.e., SQL Server and Windows Authentication mode should be enabled prior to installing the Hosting Controller.
       
       
        
  • TCP/IP and Named Pipes
    •  The status of both TCP/IP and Named Pipes should be enabled in SQL Server Configuration Manager.
       
       
  • SQL Server Browser Service
    •  The SQL Server Browser service should be running.
       
       
        
  • 'hcdbadmin' user must be the DB owner also on the new SQL machine where you are to restore the DB, as shown in the below screenshot taken from SQL Management Studio after signing in as an SQL SA user.


     4. Open the Config.exe file on your HC10 portal machine from this location: C:\Program Files\Hosting Controller\Config.exe., specify the new SQL instance and DB details which shall help to connect the new SQL DB with your HC panel.

HC9 Instructions:
  1. Take a backup of the HC database from SQL Server Management Studio.
  2. Take a backup of the ServerSetting.xml file from the existing HC db server location X:\Program Files\Hosting Controller\INI
  3. Install HC on the new SQL machine using the Database Server option.
  4. Restore the HC database backup
  5. Place the ServerSetting.xml file in the new HC SQL machine location X:\Program Files\Hosting Controller\INI
  6. Open the HC database table TblUserProp and modify the IP address for the entry " MasterServer"
  7. Modify the HC database connection in the existing HC cluster machines using the RegisteredServer.exe file located in X:\Program Files\Hosting Controller\Applications
  8. Restart hcremoting service from Services Manager Start:: Run:: Services.msc.
Note:  Please note that instructions No. 2 and No. 5 would apply only if you are using the build prior of HC 9.10. 

If you still have any questions, feel free to open a ticket with the support department by sending an email to support@hostingcontroller.com