Virtually Caffeinated

A double-shot of knowledge

Jeremy Wheeler

I am an experienced Consulting Architect for VMware’s Professional Services Organization, End-user Computing specializing in VMware Horizon Suite product-line and SDDC. I have over 23 years of experience in the IT industry. In addition to his past experience, I have a passion for technology and thrives on educating customers. Additionally, I have 10 years of hands-on virtualization experience deploying full-life cycle solutions using VMware, CITRIX, and Hyper-V. I also has 18 years of experience in computer programming in various languages ranging from basic scripting to C, C++, PERL, .NET, SQL, and PowerShell. I’ve received acclaim from several clients for my in-depth and varied technical experience and exceptional hands-on customer satisfaction skills. In February 2013, I received VMware’s Spotlight award for my outstanding persistence and dedication to customers and was nominated again in October of 2013. I was awarded 2015 – 2017 vEXPERT.

VMware App Volumes

AppVolumes 2.12 and SQL AlwaysOn Migration

Jeremy Wheeler

April 19, 2017April 19, 2017 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 :

Written by Jeremy Wheeler: Jeremy

Leave a Reply Cancel reply

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

VMware Helps Partners Perform and Transform with the Next Evolution of VMware Partner Connect August 18, 2022
Singular partner program includes multiple business models and routes to market with VMware Enhancements will recognize and reward partner capabilities and performance while delivering an elevated partner experience Incentives accelerate partner transition to SaaS, subscription, and services-based business models PALO ALTO, Calif.--(BUSINESS WIRE)-- VMware, Inc. (NYSE: VMW) today announced the ...
VMware Named a Leader in the 2022 Gartner® Magic Quadrant™ for Unified Endpoint Management for Fifth Year in a Row August 16, 2022
Company Also Receives Highest Product Scores in all Four Use Cases in 2022 Gartner® Critical Capabilities for Unified Endpoint Management Tools Report PALO ALTO, Calif.--(BUSINESS WIRE)-- VMware, Inc. (NYSE: VMW) today announced it has been positioned by Gartner, Inc. as a Leader in the 2022 Magic Quadrant for Unified Endpoint Management (UEM). This is the […]
VMware Report Warns of Deepfake Attacks and Cyber Extortion August 8, 2022
Burned out security teams fight back against geopolitically motivated attacks and lateral movement inside networks PALO ALTO, Calif.--(BUSINESS WIRE)-- At Black Hat USA 2022, VMware, Inc. (NYSE: VMW) released its eighth annual Global Incident Response Threat Report, which takes a deep dive into the challenges faced by security teams amid pandemic disruptions, burnout, and geopolitically […]