none
I tried to restore a database and failed due to different versions RRS feed

  • Question

  • That's what appeared to me

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Restore of database 'altawqeef_DB' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

    ------------------------------
    ADDITIONAL INFORMATION:

    System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.1400. That version is incompatible with this server, which is running version 15.00.1200. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18206.0+((SSMS_Rel).191029-2112)&LinkId=20476

    ------------------------------
    BUTTONS:

    OK

    What is the solution

    • Moved by Darren GosbellMVP Sunday, November 24, 2019 7:23 PM this is a db engine question
    Saturday, November 23, 2019 3:25 PM

Answers

  • build 15.00.xxxx is SQL Server 2019.

    the source backup is from build 1400, 2019-03-26

    the system you are trying to restore on is build 1200, 2018-12-11

    just uninstall your current version, and install the RTM build 


    jchang


    • Edited by jchang61 Saturday, November 23, 2019 4:15 PM
    • Marked as answer by medo1770 Friday, December 6, 2019 1:26 PM
    Saturday, November 23, 2019 4:14 PM
  • Hi medo1770,

    According to your error message, this is an issue about the SQL server versions are incompatible. The version of the SQL server that you are using are SQL 2019 CTP versions. They are pre-evaluation version. Now we can get the public release version of SQL server 2019 from here. I suggest you install SQL server 2019 RTM(15.0.2000.5) and restore the backup files on it. We can get SQL server 2019 version build numbers information from here.
    Hope this could help you.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, November 25, 2019 6:55 AM

All replies

  • uninstall version 15.00.1200 on that system, and install 15.00.1400 or later.

    given that these are release candidate builds, I would just go to RTM 15.00.2000 or 2070

    edit: if it is not a large database, and you still have access to the original system. Then instead of backup, go to Tasks ->Export Data-tier Application


    jchang


    Saturday, November 23, 2019 3:28 PM
  • Thank you for your quick response

    I Use SQL 2019 

    and SSMS 18.4

    The database is not large
    Just to learn
    I tried several ways and didn't work with me

    Saturday, November 23, 2019 3:50 PM
  • build 15.00.xxxx is SQL Server 2019.

    the source backup is from build 1400, 2019-03-26

    the system you are trying to restore on is build 1200, 2018-12-11

    just uninstall your current version, and install the RTM build 


    jchang


    • Edited by jchang61 Saturday, November 23, 2019 4:15 PM
    • Marked as answer by medo1770 Friday, December 6, 2019 1:26 PM
    Saturday, November 23, 2019 4:14 PM
  • Hi medo1770,

    According to your error message, this is an issue about the SQL server versions are incompatible. The version of the SQL server that you are using are SQL 2019 CTP versions. They are pre-evaluation version. Now we can get the public release version of SQL server 2019 from here. I suggest you install SQL server 2019 RTM(15.0.2000.5) and restore the backup files on it. We can get SQL server 2019 version build numbers information from here.
    Hope this could help you.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, November 25, 2019 6:55 AM
  • thank you all
    I have already canceled the installation of the old version and installed version 15.2000
    It worked well
    Friday, December 6, 2019 1:26 PM
  • thank you all
    I have already canceled the installation of the old version and installed version 15.2000
    It worked well
    Friday, December 6, 2019 1:29 PM