Virtually Caffeinated

A double-shot of knowledge

Menu

About Me

Profile
Jeremy Wheeler

I am a Solutions Architect with 30+ years in IT, specializing in cloud architecture, virtualization, and multi-cloud platforms like AWS, Azure, and Google Cloud. I’ve led enterprise projects like VMware’s Horizon Suite Sizing Estimator and have extensive experience with VMware Horizon, Citrix, Hyper-V, and programming languages like PowerShell, Python, and SQL. I run Smart AI Coach (https://smartaicoach.com/), helping individuals leverage AI for resumes, cover letters, and productivity. As a published author, VMware vExpert (2015-2020), and MIT-certified in AI, I am passionate about innovation and solving challenges.

Omnissa App Volumes

AppVolumes 2.12 and SQL AlwaysOn Migration
Jeremy Wheeler
2 mins

Hey all, I wanted to highlight an excellent blog post Mark Ma did about Migrating from a single SQL database with App Volumes to an AlwaysOn solution. With the recent release of App Volumes 2.12, we officially support Microsoft SQL Server AlwaysOn Availability Groups. SQL AlwaysOn Availability Groups is a great way to provide high availability and disaster recovery because live copies of your databases reside on secondary servers. By integrating SQL AlwaysOn with App Volumes, we ensure the most popular application layering product can be enjoyed by users in any situation. Uninstall 2.11 then Run setup wizard for 2.12

To accelerate your migration process, follow the steps below to migrate App Volumes from a single SQL database to SQL AlwaysOn Availability Groups (SQL 2014 Service Pack 1):

1. Launch the VMware App Volumes 2.12 Installation Wizard, and click Next.

2. Accept user agreement

3.Install App Volumes Manager

4. Launch App Volumes Manager Wizard.

5. Connect to an existing SQL Server Database (Pre-created)

6. Choose the single SQL server with the pre-created AppVolume database.

7. Choose https for secure connection.

8. Choose installation directory.

9. Install.

10. Finish.

11. Launch Manager Console.

12. Verify all services is working.

13. Stop App Volumes Manager Services

14. Backup AppVolume database.

15. Add AppVolume Database to SQL AlwaysON Availability Groups.

16. After verify Database is replicated in SQL AlwaysOn Availability Group change ODBC settings.

17. Edit 64 Bit ODBC settings.

18. Change SQL server from single SQL server to SQL AlwaysOn Availability Group Licenser.

19. Start App Volume Manager services.

20. Verify App Volumes Manager is up and running by launch the console.

I hope this post was valuable in helping you learn how to migrate App Volumes from single SQL Server database to SQL AlwaysOn Availability Groups (SQL 2014 Service Pack 2).

Share :
whosay

Written by  

I am a seasoned Solutions Architect with over 20 years of expertise in IT, specializing in cloud architecture, virtualization, and end-user computing solutions. My career highlights include working with top-tier technologies across multi-cloud platforms such as AWS, Azure, and Google Cloud. I have a proven track record of leading complex enterprise projects, including the development of tools like VMware’s Horizon Suite Sizing Estimator, which optimized hardware prediction accuracy for customers worldwide. With hands-on experience in virtualization technologies like VMware Horizon, Citrix, and Hyper-V, I excel in designing, deploying, and optimizing full-lifecycle solutions. My technical depth is complemented by 18 years of computer programming experience in PowerShell, Python, C++, .NET, SQL, and more. I am a published author and have contributed to industry literature, including works on desktop virtualization and user environment management. Recognized as a VMware vExpert for six consecutive years (2015-2020), I’ve also received multiple awards for excellence, such as VMware Spotlight and Our Best accolades. Currently, I leverage my knowledge to deliver innovative solutions, combining strategic insights and cutting-edge technologies like AI, as evidenced by my recent certification from MIT. Above all, I thrive on solving challenges and empowering teams to exceed customer expectations.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.