开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜