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?
1 Answer 1
(削除) 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.
-
Thanks for the quick response. I dont have sharepoint. hmmm let me ask the client for sql server backup.Sri– Sri2012年10月22日 09:42:11 +00:00Commented Oct 22, 2012 at 9:42
-
@sri Following your additional information, this may be incorrectpodiluska– podiluska2012年10月22日 09:51:33 +00:00Commented Oct 22, 2012 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– Sri2012年10月22日 10:16:45 +00:00Commented Oct 22, 2012 at 10:16