我有一个SQL Server 2005的MDF和LDF文件.我将它附加到SQL Server 2008并对数据进行了一些更改.现在,当我将它附加回sql server 2005 Express Edition时,它会出现版本错误.
The database ‘E:DBJOBPERS.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:DBJOBPERS.MDF’. CREATE DATABASE
is aborted. An attempt to attach an
auto-named database for file
E:DBJobpers.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.
- Use database publishing wizard to get out the script for all objects in
2008 db
07001
07002
07003
- Create a new empty database in your 2005 instance .
- Execute the above generated script in your new 2005 database.
- 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
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
