数据库＆QUOT;不能打开，因为它是661版本＆QUOT;附加.mdf文件时， [英] Database "cannot be opened because it is version 661" when attaching .mdf file

问题描述

我想MvcMusicStore.mdf连接到我的。\\在SQL Server 2008 R2管理工作室SQLEX $ P $干燥综合征实例（SQL Server版本10.0.2531）。我从这个项目中的DB：
的http：//mvcsitemap.$c$cplex.com/releases/view/67151

I am trying to attach MvcMusicStore.mdf to my .\SQLEXPRESS instance (sql server version 10.0.2531) in sql server 2008 R2 management studio. I got the db from this project: http://mvcsitemap.codeplex.com/releases/view/67151

当我试图连接我得到一个错误：

When i am trying to attach i am getting an error?:

The database 'C:\PROJECTS\CODEPLEX\TFS10\MVCSITEMAP\BRANCHES\3.1.0\SRC\MVCSITEMAPPROVIDER\MVCMUSICSTORE\APP_DATA\MVCMUSICSTORE.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.

我是否需要升级我的SQL Server或还有什么？

Do I need to upgrade my sql server or what else?

推荐答案

您的SQL Server前preSS实例2008年版本和数据库是从2008 R2。你必须升级到SQL Server防爆preSS 2008 R2来恢复数据库。不要紧，您使用Management Studio的2008 R2版本 - 数据库实例需要被更新

Your SQL Server Express instance is version 2008 and the database is from 2008 R2. You'll have to upgrade to SQL Server Express 2008 R2 to restore the database. It doesn't matter that you are using the 2008 R2 version of Management Studio - the database instance needs to be updated as well.

请参阅的SQL Server：连接不正确的版本661

这篇关于数据库＆QUOT;不能打开，因为它是661版本＆QUOT;附加.mdf文件时，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！