Database recovery problems between different SQL Server versions

Here, the version I refer to refers to the differences between 2008, and, rather than the Enterprise Edition AND THE DEVELOPMENT edition. from the official statement, SQL Server allows the database to be restored from the lower version to the higher version, but does not support the restoration from the higher version to the lower version, if we use a database of a higher version to restore the database engine of a lower version, what error will happen?

Database recovery generally refers to two aspects: one method is to restore by using the backup file; the other is to use the data file for additional restoration.

 

Let's first look at the Backup recovery method:

 

If you restore a database with 2005 in 2000, an error occurs:

 

MSG 3205, level 16, state 2, line 1
Too standby backup devices specified for backup or restore; only 64 are allowed.
MSG 3013, level 16, state 1, line 1
Restore database is terminating abnormally.

 

 

If you restore a database with 2008 in 2005, an error occurs:

 

MSG 3241, level 16, state 7, line 1
The media family on device 'C:/xxx. Bak' is incorrectly formed.
SQL Server cannot process this media family.
MSG 3013, level 16, state 1, line 1
Restore database is terminating abnormally.

 

Next, let's look at the method of appending Restoration:

 

If you use a 2005 database to append a restore under 2000, an error occurs:

 

MSG 1813, level 16, state 2, line 1
Cocould not open new database 'xxx'. Create Database is aborted.
MSG 602, level 21, state 50, line 1
Cocould not find row in sysindexes for database ID 7, Object ID 1, index Id 1.
Run DBCC checktable on sysindexes.

 

If you use a 2008 database to append a restore under 2005, an error occurs:

 

MSG 1813, level 16, state 2, line 1
Cocould not open new database 'test'. Create Database is aborted.
MSG 948, level 20, state 1, line 1
The database 'test' cannot be opened because it is version 655.
This server supports versions 612 and earlier. A downgrade path is not supported.

 

Practice also proves the official statement. In fact, there are very few databases with a higher version imported to a lower version. If you do need to do so, we recommend that you take the following steps:

 

1. Use the script generation wizard in the Manager to generate scripts for objects such as databases, tables, and stored procedures, and then execute the scripts to create these objects in a lower version of SQL Server.

2: data in the table is imported through DTS/SSIs.