故障附加SQL Server 2008数据库到SQL Server 2005 [英] Failure attaching SQL Server 2008 database to SQL Server 2005

问题描述

我在Visual Studio 2010开发ASP.net 4.0应用程序，使用SQL Server 2008数据库相连。我复制我的ASP.net应用到Web服务器IIS 6.0与SQL Server 2005的EX $ P $干燥综合征，操作系统Windows 2003的werver。
当我尝试浏览我的网站，我收到以下错误：

I developed an application in ASP.net 4.0 in visual studio 2010, connected with a SQL Server 2008 database. I copied my ASP.net application to a webserver IIS 6.0 with a SQL Server 2005 EXPRESS, OS Windows 2003 werver. When I try to browse my website I get the following error:

数据库'C：\\ TELEFOON \\ TELEFOON \\ APP_DATA \\ ASPNETDB.MDF'不能打开，因为它是655版本，此服务器支持版本611和更早版本。不支持降级路径。

The database 'C:\TELEFOON\TELEFOON\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.

无法打开新数据库'C：\\ TELEFOON \\ TELEFOON \\ APP_DATA \\ ASPNETDB.MDF。 CREATE DATABASE将终止。
  附加的文件C自动命名的数据库的尝试：\\ Telefoon \\ Telefoon \\ App_Data文件\\ ASPNETDB.MDF失败。具有相同名称的数据库不存在，或者指定的文件无法打开，或它位于UNC共享。

Could not open new database 'C:\TELEFOON\TELEFOON\APP_DATA\ASPNETDB.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file C:\Telefoon\Telefoon\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

我不明白的问题，但有一个解决方案？

I do understand the problem but is there a solution?

推荐答案

听起来像是你创建的SQL Server 2008 R2数据库中，并试图打开它的SQL Server 2008（或SQL Server 2005上？我忘了内部数据库版本号码）。你不能走回头路这样;你要么需要安装SQL Server 2008 R2可以直接恢复数据库，或者你需要创建一个空数据库，并使用SSMS向导复制表/结构（如导入/导出数据，这在版本之间不工作尽管OD的意见相反，或生成脚本选项）或第三方工具。我的博客上讲述一些第三方工具在这里：

Sounds like you created the database on SQL Server 2008 R2, and are trying to open it on SQL Server 2008 (or SQL Server 2005? I forget internal database version numbers). You can't go backwards like this; you'll need to either install SQL Server 2008 R2 to restore the database directly, or you'll need to create an empty database and copy the table/structure using the SSMS wizards (like import/export data, which DOES work between versions in spite of O.D's comments to the contrary, or the generate scripts option) or 3rd party tools. I blogged about some 3rd party tools here:

的http://bertrandaaron.word$p$pss.com/2012/04/20/re-blog-the-cost-of-reinventing-the-wheel/

这评语是更多的关于2008 R2 - > 2008年问题：

This comment was more about the 2008 R2 -> 2008 problem:

每一次发生这种情况我诅咒微软为他们绝对鲁钝的决定来命名的SQL ServerR2一个完整的版本 - 我的博客上讲述这个在这里，因为每一天似乎有混淆，2008年和2008 R2中的同释放，或2008 R2只是一个服务包：

Every time this happens I curse Microsoft for their absolutely moronic decision to name a full release of SQL Server "R2" - I blogged about this here, since every day there seems to be confusion that 2008 and 2008 R2 are the "same release" or that 2008 R2 is just a service pack:

<一个href=\"http://sqlblog.com/blogs/aaron_bertrand/archive/2011/02/09/is-sql-server-2008-r2-a-full-release-of-sql-server.aspx\" rel=\"nofollow\">http://sqlblog.com/blogs/aaron_bertrand/archive/2011/02/09/is-sql-server-2008-r2-a-full-release-of-sql-server.aspx

这篇关于故障附加SQL Server 2008数据库到SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！