Backing up the Horizon Composer database

The Horizon Connection Server backs up the Horizon Composer database as part of its own native backup process. This is the preferred method of backing up the Horizon Composer database as it will be backed up at the same time as the Horizon Connection Server AD LDS database. As these databases contain related information, it is critical that they are backed up at the same time.

The default location for the Horizon Connection Server database backups is on any Horizon Connection Server in the C:\ProgramData\VMware\VDM\backups folder. The Horizon Composer database backups will have an SVI extension and include the name of the Horizon Composer host server in the filename. In our example, the most recent Horizon Composer database backup file is named Backup-20181004180731-horcomp01_vjason_local.SVI and is the name of the dedicated Horizon Composer host server in our sample environment.

The Horizon Composer database may also be backed up using native database backup tools. This includes options such as the following:

  • Native backups based on the capabilities of the database platform, such as Microsoft SQL Server backup
  • Third-party database backup solutions
Remember that while native database backups will work, they may not be usable for restore purposes if they were not performed at the same time as the Horizon Connection Server AD LDS database backup. It is recommended you use the backups performed by the Horizon Connection Server, if you need to restore the Horizon Composer database.

Refer to your database server or backup software documentation if additional information about performing database backups is required.