SQL Archive – Deyda.net

Migration of Citrix databases

With the latest Citrix Virtual Apps & Desktops (CVAD) LTSR version, older SQL Server versions have been discontinued. If you want to keep your environment stable and supportable, there is no way around migrating the Citrix databases (site, logging, monitoring) to modern SQL servers (2019/2022). Whether cluster, always on or mirroring – the procedure remains essentially the same. In this article, I will show you step by step how to migrate securely.

1. Prerequisites

Complete backups of all Citrix databases
Backups/VM snapshots of the delivery controllers (DDCs)
New SQL Server (Cluster, Always On or Mirror)
Same SQL version on Principal and Mirror

Upgrade to Virtual Apps and Desktops Version 1912 LTSR

On December 18, Citrix Virtual Apps and Desktops (CVAD) version 1912 was released. Following a little guide to the update to the latest version.

Link to Citrix Virtual Apps and Desktops Documentation

Citrix Virtual Apps and Desktops EOM EOL Matrix

Upgrade from Citrix Virtual Apps and Desktops Current Release

On September 29, Citrix Virtual Apps and Desktops (CVAD) version 2009 was released. Following a little guide to the update to the latest version.

Link to Citrix Virtual Apps and Desktops Documentation

Create a SQL Maintenance Plan for Citrix DB

SQL Maintenance Plan

The Maintenance Plan Wizard creates jobs for the Microsoft SQL Server Agent. This allows you to perform various database management tasks at specific intervals, e.g. Backups, database health checks or database statistic updates. This should be configured for all SQL databases, as this will prevent the transaction logs from becoming excessively large. Excessively large transaction logs can make the server inefficient and unstable.