CODEWITHSUNDEEP
sql-serverdatabase-restore
Serdar Demir
Serdar Demir

Reputation: 107

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 10.50.1600 that version incompatible with this server which is running version 10.00.4000

Upvotes: 0

Views: 2232

Answers (2)

e-mre
e-mre

Reputation: 3363

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.

Upvotes: 2

Chris Shaffer
Chris Shaffer

Reputation: 32565

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.

Upvotes: 3

Related Questions