开发者

Sql server version problem when database restore

When I want to backup the SQL Server database, I get this error:

the database backup on a server running version开发者_JS百科 10.50.1600 that version incompatible with this server which is running version 10.00.4000


It sounds like maybe you are trying to restore a SQL 2008 R2 backup on a SQL 2008 server; Unfortunately, I don't think that is possible.


Backup & Restore is not possible but you can try generating database script with data and run the script on the destination server.
To do this:
Right-Click on the database...
Tasks >> Generate Scripts
... on the Options page of the wizard set "Script Data" to true.

You can also set the script compatibility by selecting "Script for Server Version" field.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜