.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Version 10.50.1600 is incomapitble with version 10.00.1600... During a Restore

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server

SQL Server 2008 R2 Express is installed on Machine A. I just installed SQL Server 2008 R2 Developer Edition on Machine B. I made a back up on Machine A. I copied the .bak file to Machine B. Using Management Studio I create an empty database on Machine B with the same name as the Database I had backed up on Machine A. Still using Management Studion I tried to restore the Backup from Machine A to Machine B. I received the Following error:

The Database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running 10.00.1600...

First, I find this message confusing. I though the Developer edition was the equivilent of the Enterprise Edition. Going on the assumption (yeah, I know) it strikes me as odd that the Express Edition has a higher version number, 50, than the Developer Edition, 00. Am I reading that correctly?

The real question here is how do I move a database from the Express Machine to the Developer machine? Neither is a production database so there are no time constraints such as Customer ordering will be down while I do the copy.

Thanks in advance for your help.


View Complete Post

More Related Resource Links

Restoring MASTER database from version 10.00.1600 to version 10.50.1600 fails with error...


Hey Guys,

I backed up the master database on a machine with SQL Server 2008 version 10.00.1600. Then I turned on SQL Server in single-user mode on the new machine with SQL Server 2008 R2 version 10.50.1600 with the following command (using sqlcmd)


Running this command gets me the following error.....

Msg 3168, Level 16, State 1, Server U15417546, Line 1
The backup of the system database on the device D:\master.bak cannot be restored because it was created by a different version of the server (10.00.1600) than this server (10.50.1600). Msg 3013, Level 16, State 1, Server U15417546, Line 1
RESTORE DATABASE is terminating abnormally.

Since i am restoring from a lower version, to a higher version, i assume the restore should be able to complete? I have not been able to find much help regarding this, so any information would be much appreciated.


SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Cannot Restore Backup from Sharepoint Server 2007 to Sharepoint Server 2010 Trial Version

After installing the trial version of Sharepointn 2010 I wanted to restore my Sharepoint 2007 sites to it but received the following error:  "The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space." I went on to create a new content database in sharepoint 2010 but it still did not work. The old database i.e the one used by the sharepoint 2007 server is SQL 2005. During the installation of the sharepoint 2010 version I selected SQl Server Express for the database. Is there any specifics for migrating from MOSS 2007 to sharepoint 2010? Thanks for helping

Restore problem with version '' on sharepoint foundation pls help !!!


Your backup is from a different version of Microsoft SharePoint Foundation and cannot be restored to a server running the current version. Tht Foundation and cannot be restored to a server running the current version. Tht Foundation and

Restore problem with version '' on sharepoint foundation pls help !!!

Your backup is from a different version of Microsoft SharePoint Foundation and cannot be restored to a server running the current version. Tht Foundation and cannot be restored to a server running the current version. Tht Foundation and cannot be restored to a server running the current version.
The backup file should be restored to a server with version '' or later

Am getting the above error while trying to restore the backup of a sitecollection developed on development server to another development server .
Kindly let me know where am doing wrong using Sharepoint managementShell with foll. cmdlet,
(Restore-SPSite -Identity URL -Path C:\....\.bak -force)
Thanks in advance !!!!

version dependency while backup restore of SharePoint 2007 Site Collections


hi all

I am aware of a version dependency on the stsadm -o backup/restore operation.

But will the same dependency exist for a content DB backup restore..

i.e. for example will we able to restore a content DB backup taken from a server with version say to a server with say assuming that the versions of SQL is the same in both cases.

Will the version difference in SQL create issues

Thanks in advance




Document Library version restore not behaving as expected on the "Name" column (file name)


After a rollback to a previous version, the value of the column "Name" in a document library is not restored. All other columns are restored properly. It seems that the column "Name" (file name) is excluded from the process of versioning.

I didn't find information on this behaviour on the internet. Any suggestions ?


Restore failing on Microsoft Tape Format version


I am trying to restore a DB from SQL Server 2008 Web edition to my localmachine which uses Express Edition.

When I run a RESTORE DATABASE command I get the error:

Msg 3243 - The media family on device 'c:\family.bak' was created using Microsoft Tape Format version 1.48. SQL Server supports version 1.0.

I can't see why its giving me this as the version on SQL on both machines is the same (except for Web vs Express)

I did a query to find the production version and other stuff and got this returned

Server:10.0.2531.0, SP1,  Web Edition (64-bit)

LocalMachine: 10.0.2531.0, SP1,  Express Edition with Advanced Services (64-bit)


Anyone know why its not working?

Restore a previous version of a document in a document library - error

  When I try to restore a previous version of a document in a document library, I get this error message:

"Updates are currently disallowed on GET requests. To allow updates on a GET, set the AllowUnsafeUpdates' property on SPWeb"

I am NOT running any custom code anywhere on my SharePoint site 

default ASPX Publishing page will not restore to previous version

I have inherited a MOSS farm that has a semi customized front page on it's publishing portal. One of the customizations is a bamboo web part that someone did something to to cause it to change the font on it to white and collapse if it had no information in it. I restored this whole site collection to a test area in a separate application pool so that I could work on it without disturbing any other users.  The Bamboo licensing broke in this web application even though the farm is licensed. I was just going to ignore that for now and concentrated on adding some web parts controlled by audiences. I got the web parts in and reacting to the correct audience but then I screwed around with it long enough to break it.

Now the customized Bamboo does not collapse and is stuck showing it's error message about the licensing, and I am unable to change the height of other web parts although I am able to change the width.

So (and here is the real problem) I thought that I would just restore a previous version of the page and try again after I got the licensing with Bamboo all straightened out. But I cannot get this page to restore an old version.

First when I was on the page showing all of the versions for this page and I would choose an older version it would complain that I had to check out the page before making any changes. SO I check out the page and return

ASP.NET 4.0: WebForm Routing (quick n dirty version)

One of the things we're adding in ASP.NET 4.0 is built-in support for using Routing together with WebForms. Now, I'm totally aware that this is possible to do already and that a number of people have posted ways of doing this with the Web Routing feature which shipped with ASP.NET 3.5 SP1. We're just adding some features to make it easier to do

how to create a mobile version of a website?


 how to create a mobile version of a website?
Is there any server support needed?
How does the browser detect whether the url is accessed via mobile device or a PC?

Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio


We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008

Team System: Team Foundation Server Version Control


In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007

C++ at Work: Web Version Checking, Adding Sound to an App


This month: CWebVersion revisited using HTTP instead of FTP, and adding sounds to an MFC-based app.

Paul DiLascia

MSDN Magazine May 2006

XML in Yukon: New Version Showcases Native XML Type and Advanced Data Handling


The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQuery language. Data integrity of the XML data type can be enforced through schema validation and XML-based check constraints, and special indexes can be defined that help speed up queries. In addition, Yukon has the built-in ability to expose its data through Web services. This article discusses these and other XML features of Yukon.

Bob Beauchemin

MSDN Magazine February 2004

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend