SQL Server:附加不正确的版本 661 [英] SQL Server: Attach incorrect version 661

问题描述

尝试将数据库文件附加到:

When trying to attach a database file to:

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 <X64> (Build 7600: )

我收到此错误消息:

无法打开数据库，因为它是版本 661.这个服务器支持 662 及更早版本.一种不支持降级路径.

The database cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported.

知道为什么吗?以及如何解决?

Any idea why? and how to solve it?

推荐答案

SQL Server 2008 数据库版本为 655.SQL Server 2008 R2 数据库版本为 661.您正在尝试将 2008 R2 数据库 (v. 661) 附加到 2008实例，这不受支持.一旦数据库升级到 2008 R2 版本，就不能降级.您要么必须将 2008 SP2 实例升级到 R2，要么必须将该数据库中的数据复制到 2008 数据库中(例如，使用数据迁移向导或类似的东西).

SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database (v. 661) to an 2008 instance and this is not supported. Once the database has been upgraded to an 2008 R2 version, it cannot be downgraded. You'll have to either upgrade your 2008 SP2 instance to R2, or you have to copy out the data in that database into an 2008 database (eg using the data migration wizard, or something equivalent).

该消息具有误导性，至少可以说是 662，因为 SQL Server 2008 SP2 确实支持 662 作为数据库版本，这是启用 15000 个分区的情况在数据库中，请参阅支持15000 个分区.docx.启用支持会将 DB 版本提升到 662，禁用它会将其移回 655.但 SQL Server 2008 SP2 不支持 661(R2 版本).

The message is misleading, to say the least, it says 662 because SQL Server 2008 SP2 does support 662 as a database version, this is when 15000 partitions are enabled in the database, see Support for 15000 Partitions.docx. Enabling the support bumps the DB version to 662, disabling it moves it back to 655. But SQL Server 2008 SP2 does not support 661 (the R2 version).

这篇关于SQL Server:附加不正确的版本 661的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！