Summary

This article describes how to perform the following tasks:

• Configure a XenDesktop site for use with a mirrored SQL Server database.

• Join a XenDesktop controller to an existing site that has been configured to use a mirrored SQL server database.

• Remove a XenDesktop controller from an existing site that has been configured to use a mirrored SQL server database.

Note: Configuring mirroring on a database for a deployed XenDesktop site requires the execution of PowerShell and database scripts; this is outside the scope of this article.

Configuring a Site for Use with a Mirrored Database

To configure a XenDesktop site for use with a mirrored SQL Server database, complete the following steps:

• Create an empty database on the principal with the Latin1_General_CI_AS_KS collation sequence.

• Configure the mirror and witness to start mirroring. For more information, see: http://technet.microsoft.com/en-us/library/ms189047.aspx.

• Deploy Desktop Studio using Advanced Deployment in one of the following two ways:

• Create the database automatically; mirroring is detected without user intervention.

• Create the database manually; two scripts are generated: one to be executed on the principal and one to be executed on the mirror. If you are executing the scripts using SQL Server Management Studio, enable the SQLCMD mode before executing the scripts. After executing the scripts, test the database connection by clicking Test connection and continue through the remainder of the wizard.

To verify mirroring after the wizard has completed, run the PowerShell cmdlet get-configdbconnection and ensure that the Failover Partner has been set in the connection string to the mirror.

Joining a Controller

To join a XenDesktop controller to an existing site that has been configured to use a mirrored SQL server database, run the Join Existing Site wizard in one of the following two ways:

• Update the database automatically; mirroring is detected without user intervention.

• Update the database manually; two scripts are generated: one to be executed on the principal and one to be executed on the mirror. If you are executing the scripts using SQL Server Management Studio, enable the SQLCMD mode before executing the scripts.

To verify mirroring after the wizard has completed, run the PowerShell cmdlet get-configdbconnection and ensure that the Failover Partner has been set in the connection string to the mirror.

Removing a Controller

To remove a XenDesktop controller from an existing site that has been configured to use a mirrored SQL server database, run the Remove Controller wizard in one of the following two ways:

• Update the database automatically; mirroring is detected without user intervention.

• Update the database manually; two scripts are generated: one to be executed on the principal and one to be executed on the mirror. If you are executing the scripts using SQL Server Management Studio, enable the SQLCMD mode before executing the scripts.

Disclaimer

This Web site might contain links to Web sites controlled by parties other than Citrix. Citrix is not responsible for and does not endorse or accept any responsibility for the contents or use of these third party Web sites. Citrix is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement by Citrix of the linked Web site. It is your responsibility to take precautions to ensure that whatever you select for your use is free of viruses or other items of a destructive nature.