List of DatabaseVersion values from RESTORE HEADERLISTONLY?
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 Goo开发者_JAVA百科gle and Bing searches do not return any references to the values for DatabaseVersion.
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
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.
精彩评论