Symptoms
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 ).
Cause
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".
Resolution
Contact pta@odin.com or TAM to trace the status of request.