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 SASE Launched by BT As A Managed Service January 20, 2022
PALO ALTO, Calif.--(BUSINESS WIRE)-- VMware today announced an agreement with BT, a leading global communications services provider, to offer multinational customers more choice and flexibility in how they embrace a cloud-first approach to networking, security, and edge computing. Under the terms of the agreement, BT will offer its customers VMware Secure Access Service Edge (SASE) […]
VMware to Present at the Jefferies Software Summit January 4, 2022
PALO ALTO, Calif.--(BUSINESS WIRE)-- VMware, Inc. (NYSE: VMW), a leading innovator in enterprise software, today announced that Zane Rowe, VMware’s chief financial officer and Sumit Dhawan, VMware’s president, will both present at the Jefferies Software Summit on Monday, January 10, 2022 at 9:00 a.m. PT/ 12:00 p.m. ET. A live webcast will be available on […]
IDC MarketScape Positions VMware As a Leader in SD-WAN Infrastructure December 1, 2021
PALO ALTO, Calif.--(BUSINESS WIRE)-- VMware, Inc. (NYSE: VMW), a leading innovator in enterprise software, today announced it has been positioned as a leader in the IDC MarketScape: Worldwide SD-WAN Infrastructure 2021 Vendor Assessment (November 2021, IDC #US47279821). The solution, VMware SD-WAN, is a cloud-delivered solution that optimizes application performance over any WAN link, ...