Jump to content
Welcome to our new Citrix community!
  • CVAD PVS DB Migration to a SQL AG


    cugcblogs

    raydavis22rnd-1.jpg by Ray Davis, CTA

    I recently moved a PVS farm that consisted of 4 servers from a Single Database instance to a SQL AG instance. I wasn’t 100% sure how to do this, so I reached John Carmody, aka @c4rm0, who sent me his blog as a reference. In this write-up, you will notice that there are very similar steps at a high level. I wanted to share my experience to confirm that it does work, and I tried to add more details so that my blog and his blog should cover all questions that may arise. Again, I wanted to clarify that this isn’t a copy of his post, but more of a report on my experiences with it and to back up the use case. 😊 The move to a SQL AG is around replicating the DB to a DR area and having the DB up for other DR requests around CVAD setup.

     

    Let’s Start

    1. In my situation, I had a Change Control in place, and I knew that I wanted to take an outage to do this. Therefore I am unsure if you can do this while maintaining uptime. Because the 4 PVS servers use the PVS database, it is hard to move the DB to an AG while the connections are ongoing from the PVS servers to the database.

    2. Stopping the stream service on the PVS servers during the change achieves the same thing. We don’t want connections to the PVS database while migrating the database.

    3. After stopping the services, they used a quick DB script to copy and restore the DB on the AG.

    Graphical user interface, text, applicationDescription automatically generated

    4. The process in action:

    Graphical user interface, text, applicationDescription automatically generated

    5. Next, we will need to open the PVS configuration Wizard to reconfigure the Database parameters.

    DMDfBMv4eMf4P2-YIL56W9VBblQ7abAC1kfGOx3lSK1lHPrLlAHbL23GuEiLtiOo3PlauZYt-KC-5mQtCUa5QlZN6AljwqSxlMMRYV_2Om1CuLQsonNii8zaOVT0y4j3ZZDcOajnUzbzgpPh07-sB5anZg9yks7cGraphical user interface, text, applicationDescription automatically generated

     

    6. In this screenshot, you will need to update the AG connection and check “Enable MultiSubnetFailover for SQL Server Always On.”

     

    Graphical user interface, applicationDescription automatically generated

     

    7. The Site Farm name will appear once the connection is established again.

     

    Graphical user interface, text, applicationDescription automatically generated

    8. Select the exiting Site.

    sicYzVc2LnxtM4SqHXIcUqr3O6tnyhuApCeb6slI

    9. Select the Existing Default Store.

    1CLVM0w9D6cuz4mrtziRWnoiM8aUQI4S2ziAaPMN4Ls2QOXjcoR6h-5_m-Ip9zQEar-vHYMFBQ3_Yw5hws2htzjMLZcSC92iW9S1roQ1wGHCBxN3PJBL2GHU6PFDwewiN8li4d2m

    10. Select the Citrix Licensing Server that you are using. It should auto-fill from what you had before as well.

    Graphical user interface, text, applicationDescription automatically generated

    11. Enter your service account information here. SOAP services to keep things going.

    Graphical user interfaceDescription automatically generated

    12. I left this the default, as PVS manages my Computer accounts.

    1Xgrb8uVmpLCAJRpSwARfllJWA6aHupDo-YNSLBkNpR2dVl_qp9GMFkxRWcO45TmUi4YE-gMqhNaKAtqlSXOYCI7AQVk0lPhH2VmwDZgfJkXflNvkw2g6SRScpfylSXmrYO8oMfL

    13. Select the Streaming Network Interfaces.

    Graphical user interface, applicationDescription automatically generated0VvrIwhophxG8GgpdcUuoquMUWfROf8BjuVgP7e9

    14. Select the other Servers for Steaming. Note: you will notice that I have 2 Servers here. Above I said I was moving 4 Servers, and 2 of them aren’t on this list. In my environment, I split the XA and XD into different PVS Servers for the environment Audit Requirement I have. There is just 2 of the servers in this example.

    Graphical user interface, text, applicationDescription automatically generatedDIJ3DlvfDtzJCPaRiBafjRvY9qDX4ixOkp7AuQoR

    15. Option here and check the settings in the Output text. Then start the services.

    A picture containing graphical user interfaceDescription automatically generatedGraphical user interface, text, applicationDescription automatically generatedj8FL0hpNYecbDtsHJVNq30DvNL_YDe8IZmgfDbde

    16. After this had been completed, and I rebooted my PVS servers. I do this, and you don’t have to.

    17. New Location

    Graphical user interface, text, applicationDescription automatically generated

    18. You can see my 01 servers are already picking up connections.

    Graphical user interfaceDescription automatically generated

    19. Then my 02 server is as well.

    Graphical user interface, text, applicationDescription automatically generated

    20. Then, I rebooted one of the PVS targets to ensure it could be steamed and verified registered in Studio.

    TextDescription automatically generated

    21. The VDA is streaming as it should.

    Zu57wNP3XQQ39MPIhdP0BXjhe5ivLJV5xAzAkF3w

    22. On two of my newer servers, I had this in the event logs. I knew what that was because I had dealt with this before. These needed the native SQL tools updated. Once this was done, the Stream process connected just fine.

           a. https://support.citrix.com/article/CTX226526

    Graphical user interfaceDescription automatically generated with medium confidence

    23. Error in Event Logs.

    hQPGzoCgDc5zqpavZ82zKZDxF6sSESD96GHdrMivliCCB_z4orIfeZHqTXFGJNphAk6-toAATyYb19MVaxfr-MOerqCoETcp-LWfkf0maSoXVavW-wzvR7p4iCg1dZNsDLcGBhPc

    24. After installing the Native SQL Tools. The Services was good on 04.

    A picture containing tableDescription automatically generated

     

    As you can see, this isn’t a complex process, and it is straightforward, and Citrix made this extremely easy, in my opinion. I hope this helps someone out there. 

    Thank you.

    ​​


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...