• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2138
  • Last Modified:

The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that sup

The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

how can we fix this ?
0
goodluck11
Asked:
goodluck11
  • 2
2 Solutions
 
Anthony PerkinsCommented:
how can we fix this ?
You cannot use RESTORE.  The best you can do is copy the schema and data.
0
 
Anthony PerkinsCommented:
If all you ahve are the backup files and you do not have the original data files and your data is less than 10GB and you cannot afford to purchase a retail edition than consider installing SQL Server 2008 R2 Express so that you can restore the database.
0
 
TempDBACommented:
this is because you are taking backup in the advanced version and trying to restore it in an older version. This is not possible in sql server. So, you need to look for other alternatives as the experts suggested above.
0
 
jogosCommented:
Version 10.00 is SQL2008, 10.50 is SQL2008R2.  

As previous posters alreay said you cannot restore a database of higher version into a lower version.

Do you have both versions availlable or is SQL2008R2-backup comming from outside company?
When available use the database copy tool to copy your db
http://msdn.microsoft.com/en-us/library/ms188664.aspx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now