List of DatabaseVersion values from RESTORE HEADERLISTONLY?

Question

Is there a published list of expected values by SQL Server version that match to the DatabaseVersion column returned by a RESTORE HEADERLISTONLY command? For example, DatabaseVersion 611 = SQL 2005 SP_ ?

Plenty of references for SQL Server build numbers to product versions (ex. SQL Server 2005 SP3 = 9.0.4035), my Google and Bing searches do not return any references to the values for DatabaseVersion.

Answer 1

The only thing that matter is to compare it with your current version:

SELECT SERVERPROPERTY('ResourceVersion');

If the Your version is equal or higher, the backup can be restored and and upgraded (with a limit, not all past versions are supported). If is lower, the backup is from a newer version and you wont be able to restore it.

Answer 2

Found this on the web. It appears that the internal version numbers do not distinguish between service packs or cumulative updates.

• SQL Server 7.0 databases have version number 515
• SQL Server 2000 databases have version number 539
• SQL Server 2005 databases have version number 611/612
• SQL Server 2008 databases have version number 655