topic App Volumes Database in Horizon Desktops and Apps https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275385#M87085 <HTML><HEAD></HEAD><BODY><P>Hi all - </P><P></P><P>I need to move the App Volumes Database (Version 2.15) from SQL 14 Enterprise to SQL 16 Enterprise. Is there a KB Article on doing this? Its a Single Instance App Volumes Server. Thanks.</P></BODY></HTML> Mon, 22 Apr 2019 15:42:52 GMT josejjcv 2019-04-22T15:42:52Z App Volumes Database https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275385#M87085 <HTML><HEAD></HEAD><BODY><P>Hi all - </P><P></P><P>I need to move the App Volumes Database (Version 2.15) from SQL 14 Enterprise to SQL 16 Enterprise. Is there a KB Article on doing this? Its a Single Instance App Volumes Server. Thanks.</P></BODY></HTML> Mon, 22 Apr 2019 15:42:52 GMT https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275385#M87085 josejjcv 2019-04-22T15:42:52Z Re: App Volumes Database https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275386#M87086 <HTML><HEAD></HEAD><BODY><P>First always make sure that the SQL versions you want to run are supported (<A href="https://www.vmware.com/resources/compatibility/sim/interop_matrix.php#db&amp;131=3001" title="https://www.vmware.com/resources/compatibility/sim/interop_matrix.php#db&amp;131=3001">VMware Product Interoperability Matrices</A>). You should then be able to do the following.</P><P></P><UL><LI>Stop App Volumes services</LI><LI>Backup the SQL database on the original</LI><LI>Restore the SQL database to the new server</LI><LI>Reconfigure the ODBC connection<UL><LI><A href="https://docs.vmware.com/en/VMware-App-Volumes/2.15/com.vmware.appvolumes.install.doc/GUID-FDF07301-8F94-489F-9A5F-1C2081828BDD.html" title="https://docs.vmware.com/en/VMware-App-Volumes/2.15/com.vmware.appvolumes.install.doc/GUID-FDF07301-8F94-489F-9A5F-1C2081828BDD.html">Configure a SQL Server ODBC Connection</A>​</LI></UL></LI><LI>Start App Volumes services</LI><LI>Test and validate functionality</LI></UL></BODY></HTML> Mon, 22 Apr 2019 16:44:14 GMT https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275386#M87086 BenFB 2019-04-22T16:44:14Z Re: App Volumes Database https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275387#M87087 <HTML><HEAD></HEAD><BODY><P>Thanks Ben.</P></BODY></HTML> Mon, 22 Apr 2019 18:43:45 GMT https://communities.vmware.com/t5/Horizon-Desktops-and-Apps/App-Volumes-Database/m-p/2275387#M87087 josejjcv 2019-04-22T18:43:45Z