Restoring the Horizon Composer database

The Horizon Composer database should be restored using the native Horizon sviconfig.exe command-line tool. This tool is located within the install directory of Horizon Composer, which is at the following location on our sample server: D:\Program Files (x86)\VMware\VMware View Composer.

You will need the following information to restore the database:

• The name of your Database Source Name (DSN) connection on the Horizon Connection Server. On our sample server, the name is Composer_Pod1.
• Horizon Composer database username. On our sample server, the name is composer.
• Horizon Composer database password. On our sample server, the password is Password123.
• The backup file path location of the Backup-20181004180731-horcomp01_vjason_local.SVI file referenced in the Backing up the Horizon Composer database section of this chapter. On our sample server, the file is located in C:\Temp.

The following steps outline the process used to restore the database, using the information from our sample server:

1. Stop the VMware Horizon Composer service.
2. From the Command Prompt, navigate to the Horizon Composer installation directory.
3. Execute the following command to restore the Horizon Composer database backup. A screenshot that shows the command input is provided after the command:

        sviconfig -operation=restoredata -dsnname=Composer_Pod1 -
        username=composer -password=Password123 -
        backupfilepath="C:\Temp\Backup-2018-1004180731-
        horcomp01_vjason_local.SVI."

1. The restore process should output several lines of status information. The last few lines of the output are shown in the following screenshot, the last of which indicates that the restore was successful:

1. Start the Horizon Composer service.

Horizon Composer is now operating with the restored database.