?
Solved

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

Posted on 2012-03-21
4
Medium Priority
?
1,924 Views
Last Modified: 2012-03-27
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
Comment
Question by:goodluck11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37750588
how can we fix this ?
You cannot use RESTORE.  The best you can do is copy the schema and data.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37750597
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
 
LVL 25

Accepted Solution

by:
TempDBA earned 1200 total points
ID: 37751066
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
 
LVL 25

Assisted Solution

by:jogos
jogos earned 800 total points
ID: 37751157
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question