Changing a Production XenDesktop 7.1 Site to use SQL Mirroring

Changing a Production XenDesktop 7.1 Site to use SQL Mirroring

In a previous article, I changed my lab’s PVS Farm to use SQL database mirroring.  Since that has been done it is time to change my XenDesktop 7.1 Site to also use SQL database mirroring.  I will document the process I found that worked.  It is not all like what is described in CTX127538 How to Reconfigure a XenDesktop Site to Use a Mirrored Database but that article does have some valid information in it. I will also use information gleaned from two Citrix blogs: XD Tipster – SQL Mirroring: Just the Skinny Please… and XenDesktop 7.x Database Migration.  They are helpful but they don’t have 75 screen shots!

Citrix XenDesktop Personal vDisk Stats using Microsoft Excel and PowerShell V2.1

Citrix XenDesktop Personal vDisk Stats using Microsoft Excel and PowerShell V2.1

Yeah, I know.  I just updated the script a couple of days ago and here is another update.  Well, I just couldn’t stand it that the script couldn’t support sending email over anything but the default SMTP port 25.  I just had to fix that but doing so required basing the script on PowerShell version 3.  The script now requires at least PowerShell version 3 and there are a couple of more parameters.