Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed an instance of SQL Server 2008 Express Edition but when trying to restore a db file - bak, I receive 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 version 10.00.1442. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server." I assume this error is generated because the bak file was backed up on a sql server 2008 R2. My question is how can I upgrade my database server to 2008 R2 Express Edition so I can restore this file? Or if there is any other option to import the file using the already installed version..

share|improve this question

migrated from Apr 20 '11 at 23:39

This question came from our site for professional and enthusiast programmers.

This is not a programming question, and is off-topic here. Voting to move to superuser – Ken White Apr 20 '11 at 22:11

Here is a walkthrough on how to upgrade a SQLExpress 2008 instance to SQLExpress 2008 R2 version

share|improve this answer

10.50.1600 is SQL Server 2008 R2, and 10.00.1442 - they are separate versions, and 2008R2 is a later version. You can't do a restore down the versions, only to identical or higher versions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.