This article will cover the steps necessary to migrate an existing PVS database to a new database on an existing SQL server or to a new database on a new SQL server.

Instructions

1. Backup the existing PVS database.
2. Restore the PVS Database on the new SQL server following Microsoft best practices for database restoration.
3. Shutdown all target devices.
4. Run the configuration wizard on the first PVS server and choose “Join existing farm”.
5. Specify the new server and database and finish running the wizard.
6. Complete the previous step for all PVS servers in the farm.
7. Begin booting the target devices.

Important - Please Read Prior To Performing Any Actions

It is not recommended to make any changes to the PVS software in between the backup and restore of the DB.  Target Devices deployed after a DB restore with an updated vDisk (newer target software than the PVS server software versions) can expect to see some software mismatch related problems such as a Domain Trust Relationship Error during logon.  See: https://support.citrix.com/article/CTX270842

1. Copying Databases with Backup and Restore
As all PVS servers available in FARM will use the same database instance, it's required to shutdown all target devices before starting the migration.

2. In rare instances after DB restoration machines that were powered on and not able to immediately speak with the domain due to networking or policies or domain variation in the new environment resulted in Microsoft Domain Trust issues.  If a Target Device experiences this problem it is required that you power it down and reset the Targets MAP (machine account password) from the PVS console.