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

问题描述

我正在尝试在 sql server 2008 R2 管理工作室中将 MvcMusicStore.mdf 附加到我的 .SQLEXPRESS 实例(sql server 版本 10.0.2531).我从这个项目中得到了数据库:http://mvcsitemap.codeplex.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:PROJECTSCODEPLEXTFS10MVCSITEMAPBRANCHES3.1.0SRCMVCSITEMAPPROVIDERMVCMUSICSTOREAPP_DATAMVCMUSICSTORE.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 Express 实例是 2008 版，数据库是 2008 R2 的.您必须升级到 SQL Server Express 2008 R2 才能恢复数据库.使用 2008 R2 版本的 Management Studio 并不重要 - 数据库实例也需要更新.

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

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