Sql server version problem when database restore

2020-05-03 12:48发布

问题:

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

the database backup on a server running version 10.50.1600 that version incompatible with this server which is running version 10.00.4000

回答1:

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.



回答2:

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.