By rem


2011-08-22 14:32:45 8 Comments

When trying to restore a backup to a SQL Server Express 2008 database I got the following error:

Restore failed for Server '...\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: The database was backed up on a server running version
10.50.1600. 
That version is incompatible with this server, which is running version 10.00.2531. 
Either restore the database on a server that supports the backup, or use a backup 
that is compatible with this server. (Microsoft.SqlServer.Smo)

Is there a way to get a backup which is compatible with the older (in my case 10.00.2531) version from the newer (in my case 10.50.1600) version of SQL Server Express?

5 comments

@dsingh 2014-05-09 05:20:14

SQL Server backup doesn't support backward compatibility

Steps to get DB on older versions -

  • For Schema: right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "schema" -->ok -->next -->next

  • For Data: right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "data" -->ok -->next -->next

@Iman 2017-02-21 13:40:03

One problem with this method is for big databases (many tables, and huge data) running scripts to restore takes long time. but it is handy and easy

@Sarah 2013-05-19 15:23:24

right click on your database --> Tasks --> generate scripts -->next-->next--> click on advanced button --> change the option "type Of Data to script" to "schema and data" -->ok -->next -->next so now you have a script that creates database and its table and fills the data in it :) ;)

@Thomas Rushton 2013-05-19 15:39:17

Depending on the amount of data, that script could be enormous...

@ErikE 2013-10-11 00:19:19

@ThomasRushton That script is by definition going to be bigger than the database itself, probably by at least double if not worse! I hope it's not a 50 GB database...

@Burgi 2016-09-02 09:34:10

This is a duplicated answer

@juFo 2017-03-08 08:12:36

this is not a duplicate answer, it is a great answer at the type of data is "schema AND data" ! ;-) which is what I needed!

@basher 2017-05-26 19:31:10

@Burgi this answer is older than dsingh's. He simply copied Sarah's and added 2 options, 1 for schema the other for data. His is the duplicate.

@SQLRockstar 2011-08-22 14:42:44

The only way is to create a new database on the 10.00.2531 version and import the data from 10.50.1600.

You can't restore down to an older version.

@gbn 2011-08-22 14:42:25

You'd have use the Import/Export wizards in SSMS to migrate everything

There is no "downgrade" possible using backup/restore or detach/attach

@Richard 2011-08-22 14:41:53

You can use the Import/Export wizard to move data between databases.

Right click on the database you want to export, choose "Tasks", then "Export Data". The wizard will guide you through the process.

You're right, though. You won't be able to do a backup/restore moving from SQL Server 2008 R2 to SQL Server 2008 Express.

Related Questions

Sponsored Content

2 Answered Questions

[SOLVED] Error on SQL Server 2000 backup (.bak file) restored on SQL Server 2012

  • 2012-11-22 11:00:20
  • Antonio Feliziani
  • 6892 View
  • 6 Score
  • 2 Answer
  • Tags:   sql-server

1 Answered Questions

[SOLVED] Restore of database failed .bak file SQL Server 2008

2 Answered Questions

[SOLVED] Error when restoring SQL Server 2008 R2 backup on 2012

1 Answered Questions

[SOLVED] Restore failed for server (Microsoft.SqlServer.SmoExtended)

1 Answered Questions

Sponsored Content