sql-server-2008 – SQL Server 2008到SQL Server 2005

前端之家收集整理的这篇文章主要介绍了sql-server-2008 – SQL Server 2008到SQL Server 2005前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我有一个sql Server 2005的MDF和LDF文件.我将它附加到sql Server 2008并对数据进行了一些更改.现在,当我将它附加回sql server 2005 Express Edition时,它会出现版本错误.

The database ‘E:\DB\JOBPERS.MDF’
cannot be opened because it is version
655. This server supports version 612 and earlier. A downgrade path is not
supported. Could not open new database
‘E:\DB\JOBPERS.MDF’. CREATE DATABASE
is aborted. An attempt to attach an
auto-named database for file
E:\DB\Jobpers.mdf Failed. A database
with the same name exists,or
specified file cannot be opened,or it
is located on UNC share.

解决方法

我知道问题是什么,它是退出描述性错误.但是在问这个问题的解决方案.无论如何,感谢大家的回复.

任何面临同样问题的人,请参阅下面的说明并阅读LEKSS回复
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/46ce6099-61c6-4526-9dda-10a3359386cb

希望这会有所帮助

更新:引用外部链接以便安全保存

The database ‘ASPNETDB.MDF’ cannot be opened because it is version 655. This server
supports version 612 and earlier.

You cannot backup/restore or
detach/attach from a higher version to
a lower version.

  1. Use database publishing wizard to get out the script for all objects in
    2008 db

07001
07002
07003

  1. Create a new empty database in your 2005 instance .
  2. Execute the above generated script in your new 2005 database.
  3. Move your sql server logins/users from 2008 database to 2005 database
    using sp_help_revlogin stored
    procedure.

Thanks,Leks

Proposed As Answer byyup. _ Sunday,May 09,2010 10:14 AM Marked As Answer byTom Li – MSFTMicrosoft,ModeratorThursday,May 20,2010 4:58 AM

原文链接:https://www.f2er.com/mssql/76635.html

猜你在找的MsSQL相关文章