Office 365 Endpoint upgrade fails:
... Configuring application 'O365App'... Trying to detect SQL Server connection string from existing configuration... Deploying the database... ERROR Deployment failed: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. Error SQL72014: .Net SqlClient Data Provider: Msg 1468, Level 16, State 2, Line 5 The operation cannot be performed on database "Office365GatewayApplication01" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. Error SQL72045: Script execution error. The executed script: IF EXISTS (SELECT 1 FROM [master].[dbo].[sysdatabases] WHERE [name] = N'$(DatabaseName)') BEGIN ALTER DATABASE [$(DatabaseName)] SET RECOVERY SIMPLE WITH ROLLBACK IMMEDIATE; END
Office 365 Endpoint database itself is a part of MS SQL Always On Availability Group ( documentation link ).
Script fails on attempt to set the
Simple Recovery Model ( documentation link ) which differs from the current one.
The issue has been addressed to Odin Development team as request #APSA-19580: "Fix deployment scripts for high availability db".
Contact email@example.com or TAM to trace the status of request.