Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am using SQL Server 2012 Express edition. Client sent me the SQL Server backup file with the extension .sps.bak. I am not able to open it with SSMS. Please somebody help me here.

I get the following error message.

Restore of database failed.
System.Data.SqlClient.SqlError: 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. Either restore the database on a server that supports the backup or use a backup that is compatible with this server
.

I cannot open the database that was developed with a professional edition on an Express edition?

share|improve this question

migrated from stackoverflow.com Oct 22 '12 at 11:20

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

add comment

1 Answer 1

up vote 1 down vote accepted

That's probably a Sharepoint backup. Restore it in Sharepoint, or ask for a SQL server backup

Your error message shows that you are connected to a SQL 2008 server, not SQL 2012, and that the backup was performed on a SQL 2008 R2 server. You need an R2 server, or SQL 2012, to restore it.

share|improve this answer
    
Thanks for the quick response. I dont have sharepoint. hmmm let me ask the client for sql server backup. –  Sri Oct 22 '12 at 9:42
    
@sri Following your additional information, this may be incorrect –  podiluska Oct 22 '12 at 9:51
    
Hi Podiluska, You are right. The problem was with version compatibility. Now i am able to restore the database with sql server 2012 express edition. Thanks so much for your help... –  Sri Oct 22 '12 at 10:16
add comment

Your Answer

 
discard

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