BC 14 Cumulative Update Issue

Dynamics2018

ello everyone,

i am doing BC14 Cumulative update from CU 16 to CU23. It is only platform update.

When I try to convert database then I am getting below error 1 and is not able to proceed.

SQL Server is Azure managed instance and I am trying make database single user from within Business Central and using SQL Query but get error 2.

Any suggestion/help is appriciated.

ALTER DATABASE [DatabaseName] SET SINGLE_USER

Error 1:



Error 2:

Dynamics2018

We were not able to restore Database backup from SQL Azure Managed instance to SQL on prem due to version conflict.

The solution is that we have adapted is that taken database backup from Azure SQL Managed instance and restore it to Azure SQL Server and perform conversation.

Developer101

Apparently it is not possible to do in the azure managed sql databases, it is a limitation. It is possible to do the conversion else where and then put back the database on azure?

Dynamics2018

Thank you for suggestion.

We have already tried the option that you have provided but Admin was not able to install database backup from Azure Managed instance to local SQL Server as Azure managed instance SQL version is higher than available on-Prem version

Developer101

Try using the latest free development edition of sql instance onprem for the conversion

Dynamics2018

We were not able to restore Database backup from SQL Azure Managed instance to SQL on prem due to version conflict.

The solution is that we have adapted is that taken database backup from Azure SQL Managed instance and restore it to Azure SQL Server and perform conversation.