This article describes how to back up and restore a XenDesktop database on Microsoft SQL Server.
This article assumes you are an SQL administrator with basic knowledge of SQL Server or appropriate resources to assist with the execution of the SQL statement command.
When using Microsoft SQL Server, consult the Database Server product documentation for scheduling automated backups of the data store. In most cases, daily backup is sufficient to prevent loss of farm data.
Step by step instructions on how to backup and restore Citrix XenApp and XenDesktop databases can be found in the following Citrix support article: https://support.citrix.com/article/CTX135207