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
1,755 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
  • 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 300 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 200 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 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