无法打开数据库,因为它是版本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.

查看:393
本文介绍了无法打开数据库,因为它是版本661.此服务器支持版本662及更早版本。不支持降级路径。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个数据库,在SQl-Server R2中创建。



现在我使用C#创建了一个桌面应用程序,并希望将此数据库附加到我的应用程序中,

但是当我尝试添加数据库.MDF文件时,它会给出这样的错误...



数据库无法打开,因为它是版本661.此服务器支持版本662和更早版本。不支持降级路径。









i了解视觉工作室有较低版本的SQL数据库,所以我安装了Visual Studio 2012,

但问题又一样......



那么什么可以我这样做,以及我如何更新我的Visual Studio 2010,2012的Sql server ...



我的数据库大小是3 GB,所以我也无法创建数据库SCript然后执行它..





所以plz提供和喜欢更新我的默认Sql服务器,它在视觉stdio内部安装2010,2012 ..





相同的问题是

http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661 [<一个href =http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661target =_ blanktitle =New Window> ^ ]

解决您可能已经安装了VS 2012,但是您正在使用SQL 2008实例:Visual Studio不会为您安装SQL。

SQL Server 2008数据库的版本为655. SQL Server 2008 R2数据库为661.您尝试将2008 R2数据库附加到2008实例,但不支持此操作。



您需要将SQL实例升级到至少2008R2才能打开文件(但请注意,如果您随后将现有数据库附加到新实例,则您赢了然后能够再次在SQL 2008中打开。)


这些链接可能对你有用



http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version- 661 [ ^ ]





http://conceptdev.blogspot.com/2009/04/mdf-cannot-be-opened-because-it-is.html [ ^ ]

i have a Databse,Created in SQl-Server R2.

Now i made a Desktop application using C#,and want to Attach this databse into my application,
but when i try adding the database .MDF file it give error like this...

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





i understand that visual studio have Lower version of SQL database,so i install Visual studio 2012,
but again the problem is same...

so what can i do,and how i update Sql server of my Visual studio 2010,2012...

and my database size is 3 GB, so i also unable to Make Database SCript and then Excute it..


so plz provide and Like for update my default Sql server,which is internally install in visual stdio 2010,2012..


Same Prob is
http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661[^]

解决方案

You may have installed VS 2012, but you are using a SQL 2008 instance: Visual studio does not install SQL for you.
SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database to an 2008 instance and this is not supported.

You need to upgrade your SQL instance to at least 2008R2 to open the file (but be aware that if you subsequently attach your existing DBs to the new instance, you won't be able to open then in SQL 2008 again either).


these links may be useful for you

http://stackoverflow.com/questions/4257684/sql-server-attach-incorrect-version-661[^]


http://conceptdev.blogspot.com/2009/04/mdf-cannot-be-opened-because-it-is.html[^]


这篇关于无法打开数据库,因为它是版本661.此服务器支持版本662及更早版本。不支持降级路径。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
相关文章
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆