如何附加数据库? [英] How can I attach a database?

问题描述

当我想附加数据库时，出现错误:

When I want to attach database, an error occurs:

无法打开数据库Almizan"，因为它的版本是 661.
此服务器支持版本 655 及更早版本.不支持降级路径.
无法打开新数据库Almizan".CREATE DATABASE 已中止.
(.Net SqlClient 数据提供程序)

The database 'Almizan' cannot be opened because it is version 661.
This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'Almizan'. CREATE DATABASE is aborted.
(.Net SqlClient Data Provider)

帮我附加这个数据库.

推荐答案

安装 SQL Server 2008 EXPRESS R2.Web 平台安装程序存在错误，它仍然认为 EXPRESS R1 是最新版本.

Install SQL Server 2008 EXPRESS R2. There is a bug in the Web Platform Installer and it still thinks EXPRESS R1 is the latest version.

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 个分区时，请参阅 Support for 15000 Partitions.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).

这篇关于如何附加数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！