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..
2 Answers
Here is a walkthrough on how to upgrade a SQLExpress 2008 instance to SQLExpress 2008 R2 version
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.