把MDF文件从一个sql server 2008转移到另一个sql server 2008时打不开

Question

我把一个sql server 2008的一个数据库的MDF和LDF文件都复制走，然后再另一个sql server 2008中，通过

数据库-》附加-》添加，然后选择MDF文件，下面LDF文件也列出来了，点确定后就出现附加数据库时出现错误，信息如下：

无法打开新数据库 'RampUp'。CREATE DATABASE 中止。

消息 948，级别 20，状态 1，第 1 行

数据库 'RampUp' 的版本为 661，无法打开。此服务器支持 662 版及更低版本。不支持降级路径。

我都已经都把SQL SERVER 2008升级到SP2了，都说支持662的怎么还打不开661的啊。

Answer 1

Build 661 is sql2k8 r2, can't attach that db in sql2k8. Sql2k8 sp2 reports build 662 because it supports 15000 partitions, same as sql2k8 r2 sp1 does. But that doesn't make sql2k8 same version as sql2k8 r2. You can disable this new feature in the db by the way, that'll pull the db backup to build 655.

Answer 2

OK.

I can't attach the db in sql server 2008 or sp1. So I want to know which version can I use to attach the db.

By the way, how can I disable the new future in db.

Answer 3

Can only attach to sql2k8 r2 server.

Answer 4

Yes,

rmiao was absolutely right, for version 661 is for Sql2k8 r2. so you need to update your sql server to 2k8 R2 to attach your db file.

You can download R2 trial from this link http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx.

Hope this helps.

Chao

---

Please unmark it if it does not help, and mark it if it helps.