Implementing database mirroring for the App-V data store
As you probably know already, the App-V Management Service controls the read/write access in the App-V database, when we are using the App-V Management Server, and that if the database is not available, this Management Server won't be able to answer client requests or requests from Management Console access.
Providing high availability to this component in App-V should be considered in every scenario. One of the methods available to do so is mirroring the database to a separate SQL Server; this is supported by App-V.
The procedure to implement it consists of the following steps:
Preparing the database for mirroring
Configuring SQL database mirroring
Configuring the App-V Management Server for database mirroring
For more information regarding the functionalities in SQL Server 2008 R2 and database mirroring, please visit the Database Mirroring Overview page at http://msdn.microsoft.com/en-us/library/ms189852.aspx.
