Can't restore databse on Microsoft SQL server management studio

Manwinder Singh 1 Reputation point
2022-06-07T02:12:05.533+00:00

===================================

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

Program Location:

at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)
at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.Perform(ITaskExecutionContext context)
at Microsoft.SqlServer.Management.TaskForms.TaskExecutionManager.ExecuteTaskSequence(ISfcScriptCollector collector)

===================================

System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.2000. That version is incompatible with this server, which is running version 13.00.4001. 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=16.100.47008.0&LinkId=20476

Program Location:

at Microsoft.SqlServer.Management.Smo.RestorePlan.Execute()
at Microsoft.SqlServer.Management.RelationalEngineTasks.RestoreDatabaseTaskFormComponent.PerformTask(ITaskExecutionContext context)

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,767 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,901 Reputation points
    2022-06-07T05:43:56.67+00:00

    The database was backed up on a server running version 15.00.2000. That version is incompatible with this server, which is running version 13.00.4001.

    You got a clear error message. The backup comes fro a newer SQL Server version; it's not backwart compatible and you can restore a backup from a nwer SQL Server version to an older one.

    1 person found this answer helpful.
  2. Naomi 7,361 Reputation points
    2022-06-07T03:24:45.867+00:00

    SQL Server backup which is made in higher version (SQL Server 2019 ?) is not compatible with lower version of SQL Server. What is the result of SELECT @@VERSION?

  3. murali menon 1 Reputation point
    2022-06-07T06:08:48.777+00:00

    Option 1: create a .bak and restore.

    However, with this option 1, it's not always possible to downgrade a SQL database backup from a higher version to a lower one.

    Here are other options you could try:

    Option 2: You can export the source database as scripts (i.e DDL and DML) and then run the scripts on the destination database.

    Note: DDL statements are used to create database, schema, constraints, users, tables etc. DML statement is used to insert, update or delete the records

    Option 3: Upgrade the source database and then take a backup and restore the backup on the destination database.

    Let me know if this works for you?

    0 comments