We all know that the database files of the advanced version cannot be restored or appended to the lower version, because the format of the files of the higher version and the lower version is different. If you try to append or restore a database of a lower version to a database of a lower version, you will see
We all know that the database files of the advanced version cannot be restored or appended to the lower version, because the format of the files of the higher version and the lower version is different. If you try to append or restore a database of a lower version to a database of a lower version, you will see
We all know that the database files of the advanced version cannot be restored or appended to the lower version, because the format of the files of the higher version and the lower version is different. If you try to append or restore a database of a lower version to a database of a lower version, you will see an error similar to the following:
The disk structure version of The backed-up database is 611, the server version is 539, and the Hong Kong server is rented. The database cannot be restored or upgraded. The restore filelist operation ends abnormally. (MicrosoftSQL Server, error: 3169)
Here I have found the configuration table (ternal SQL Server Database Version Numbers) of the internal Database Version corresponding to all SQLServer versions on the Internet ):
Target SQL Server Version
Source SQL Server Version
Internal Database Version
SQL Server 2008 R2
SQL Server 2008 R2
665
SQL Server 2008
661
Sqlserver 2005 with vardecimal enabled
612
SQL Server 2005
611
SQL Server 2000
539
SQL Server 2008
SQL Server 2008
661
Sqlserver 2005 with vardecimal enabled
612
SQL Server 2005
611
SQL Server 2000
539
SQL Server 2005 SP2 +
Sqlserver 2005 with vardecimal enabled
612
SQL Server 2005
611
SQL Server 2000
539
SQL Server 7
515
SQL Server 2005
SQL Server 2005
611
SQL Server 2000
539
SQL Server 7
515
SQL Server 2000
SQL Server 2000
539
SQL Server 7
515
SQL Server 7
SQL Server 7
515
In this configuration table, we can see that the cause of the error is to try to restore the 2005 backup file to 2000. If you do not have version 2005, you can only export the 2005 database script to version 2000 and then import the data.
Description of the DATABASEPROPERTYEX 'version' option on MSDN:
The internal version number of the SQL Server code used to create a database ..
This article is from the "Pay attention to SQL Server Technology" blog, American Server, please be sure to keep this source