将数据库从sqlexpress2008还原到sqlexpress2014 [英] Restore database from sqlexpress2008 to sqlexpress2014

问题描述

美好的一天，



我确实尝试从sqlExpress2008备份我的数据库并在sqlExpress2014中恢复它。但当我执行此操作时，它会以这种错误返回给我



'Msg 3169，Level 16，State 1，Line 1

数据库已在运行版本8.00.2039的服务器上备份。该版本与此服务器不兼容，该服务器运行的是版本12.00.2000。在支持备份的服务器上恢复数据库，或使用与此服务器兼容的备份。

消息3013，级别16，状态1，行1

RESTORE DATABASE正在异常终止。'







有什么方法可以解决这个问题吗？



非常感谢专家。



我尝试了什么：



我确实尝试使用sql备份恢复恢复它并使用脚本都返回同样的错误。



谢谢

good day,

i did try to backup my database from sqlExpress2008 and restore it in sqlExpress2014. but when i perform this operation it return me with this kind of error

'Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 12.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.'



is there any way for me to solve this problem?

thank you very much experts.

What I have tried:

I did try to restore it using sql backup restore and using script both return me same error.

Thank you

推荐答案

请检查：我们可以在SQL Server 2014上恢复SQL Server 2008R2备份吗？ - 堆栈溢出 [ ^ ]



这也可能有用：使用分离和附加（Transact-SQL）升级数据库 [ ^ ]

Please, check this: Can we restore SQL Server 2008R2 backup on SQL Server 2014? - Stack Overflow[^]

This might be useful too: Upgrade a Database Using Detach and Attach (Transact-SQL)[^]

这篇关于将数据库从sqlexpress2008还原到sqlexpress2014的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！