How to backup and restore Citrix XenApp and XenDesktop databases
Objective
Section titled “Objective”This article describes how to back up and restore a XenDesktop database on Microsoft SQL Server.
Requirements
Section titled “Requirements”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.
Background
Section titled “Background”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