如何附加在visual studio MS-SQL服务器中降级的数据库版本 [英] How do I attach a Database version downgraded in visual studio MS-SQL server

问题描述

我正在使用Visual Studio 2010，MS-SQL Server 2008 R2，

我的项目是在asp web表单中使用C＃。

我有两个数据库即test .mdf和database.mdf。

我已经附加了test.mdf并且成功运行良好。

但是现在当我附加database.mdf时，它显示以下内容错误。

拜托，我帮帮我。我只知道asp.net中的业余（基础）级别。



请点击此链接查看弹出的错误。

http://goo.gl/egYsz3 [ ^ ]

I am using Visual Studio 2010, MS-SQL Server 2008 R2,
My project is using C# in asp web form.
I have two databases namely "test.mdf" and "database.mdf".
I already attached test.mdf and successfully working good.
But now when I attach database.mdf, it shows the following error.
Please, I help me out. I know only amateur(basic) level in asp.net.

Please click this link to see the error which it pops up.
http://goo.gl/egYsz3[^]

推荐答案

简单的答案是，你不能。您必须升级到更高版本的SQL Server。

The simple answer is that you cannot. You must upgrade to a later version of SQL Server.

Quote：

A由较新版本的SQL Server创建的数据库无法附加或还原到早期版本。此限制仅仅是因为旧版本无法了解较新版本中引入的文件格式更改。

A database created by a more recent version of SQL Server cannot be attached or restored to an earlier version. This restriction is simply because an older version cannot know about file format changes that were introduced in the newer release.

有关内部SQL Server版本号，请参阅此页： http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx [ ^ ]。



错误显示您正在尝试将SQL Server 2008数据库附加到SQL Server 2005 SP2实例。确保已将connectionstring配置为指向PC上运行的正确SQL Server实例。您可能有多个实例在运行。打开SQL Server配置管理器，并检查SQL Server服务下的列表以查看计算机上运行的实例。

See this page for the internal SQL Server version numbers: http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx[^].

The error shows that you are trying to attach a SQL Server 2008 database to a SQL Server 2005 SP2 instance. Make sure you have configured your connectionstring to point to the correct SQL Server instance running on your PC. You might have multiple instances running. Open the SQL Server Configuration Manager, and check the list under 'SQL Server Services' to see the instances running on your machine.

我安装了SQL Server的更新版本，它解决了我的问题。感谢您抽空帮助我。

I installed an updated version of SQL Server and it solved my problem. Thanks for your time to help me.

这篇关于如何附加在visual studio MS-SQL服务器中降级的数据库版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！