SQL Server 2005数据库附加问题 [英] SQL Server 2005 DB Attach Problem

问题描述

大家好，

我的问题是这样的-

在为演示应用程序附加SQL数据库时，出现以下错误-

Hi everyone,

My problem goes something like this-

While attaching the SQL database for my demo application, I got following errors -

<br />
<br />
TITLE: Microsoft SQL Server Management Studio Express<br />
------------------------------<br />
Attach database failed for Server ''NHMS\SQLEXPRESS''. (Microsoft.SqlServer.Express.Smo)<br />
For help, click: go.microsoft.com/<br />
------------------------------<br />
ADDITIONAL INFORMATION:<br />
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)<br />
------------------------------<br />
The database ''C:\USERS\JON\DOCUMENTS\JON-SHARE\MVCMUSICSTORE\MVCMUSICSTORE\APP_DATA\MVCMUSICSTORE.MDF'' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.<br />
Could not open new database ''C:\USERS\JON\DOCUMENTS\JON-SHARE\MVCMUSICSTORE\MVCMUSICSTORE\APP_DATA\MVCMUSICSTORE.MDF''. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)<br />
For help, click: go.microsoft.com/><br />
<br />
<br />

有没有人遇到这样的问题?
有什么解决方法吗?

在此先感谢
-Neo182

Has Any one got such problem?
Any Solution Please?

Thanks in Advance
-Neo182

推荐答案

问题是SQL Server 2008 MDF文件与SQL Server 2005不向后兼容，因此您需要在SQL Server 2005上重新创建数据库并使用该数据库MDF文件，或者您需要使用脚本而不是通过附加现有数据库MDF文件在客户端生成数据库.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx [

The problem is that SQL Server 2008 MDF files are not backwards compatible with SQL Server 2005 so you need to recreate your database on SQL Server 2005 and use that MDF file or you need to generate your database on the customer side using a script and not through attaching an existing database MDF file.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx[^]

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