SQL Server 2019: Creating new database fails and ends up with “invalid column name: is accelerated database recovery on” (error 207),

Jamal NUMAN 46 Reputation points
2020-12-05T09:10:44.413+00:00

SQL Server 2019: Creating new database fails and ends up with “invalid column name: is accelerated database recovery on” (error 207),

I couldn’t figure out why creating new database fails and ends up with “invalid column name: is accelerated database recovery on” (error 207).

What could be the issue here?

45413-clip-15.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,850 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2020-12-07T06:10:23.46+00:00

    Hi @Jamal NUMAN ,

    SSMS 18.7.1 is the latest version of SSMS, we suggest you using it.

    SQL server 2019 RTM has been released for a long time, please uninstall the SQL Server 2019 CTP 2.2 (Community Technology Preview 2.2)( 15.0.1200.24), install SQL server 2019 RTM and apply CU8 for SQL 2019 as others mentioned.

    Download SQL server 2019 RTM.
    Cumulative Update 8 for SQL Server 2019

    You can follow the steps from this document to uninstall SQL 2019 CTP2.2.
    Uninstall an Existing Instance of SQL Server (Setup)

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 102.2K Reputation points
    2020-12-05T10:04:01.62+00:00

    The problem is that you are running a preview version of SQL 2019, one which apparently predates the introduction of Accelerated Database Recovery.

    Uninstall your preview version and install the released version. Also do not forget to apply the most recent Cumulative Update, which is CU8.

    If you have database you want to keep, you will need to script them and bulk out the data. As I recall, there were breaking changes around CTP 3.0, you will not be able to restore backups on the released version.

    7 people found this answer helpful.
    0 comments No comments

  2. Jamal NUMAN 46 Reputation points
    2020-12-06T19:09:16.627+00:00

    Thanks Erland,

    I just uninstalled the mamagment studio 18.7.1 and replaced it with 18.3.1 and it works fine

    Sure. I’ll be using the released version instead of the preview later

    1 person found this answer helpful.

  3. Jamal NUMAN 46 Reputation points
    2020-12-07T19:10:44.83+00:00

    Thank you guys for the help
    best
    Jamal