asked on

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.2531

Hi All

I have a database that needs to go on my line server, however, when i try and restore it i get the above message

I built the database on my local box, and I'm concerned about upgrading the live server incase it breaks the existing databases

How can I restore without upgrading sql server

if i cant, is the upgrade painless or can it be problematic?

Thanks

ASKER CERTIFIED SOLUTION

Humpdy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Humpdy

Can you also do this on both servers and give the output here

select @@version

subhashpunia

I think such issue (not able to restore on server of same version 2008 having different service pack or level as 10.50.1600 and 10.00.2531) was not there in earlier versions (sql server 2000 or 2005).
I think in SQL 2000 and SQL 2005 we are able to restore a backup of higher service pack (like sp3 or sp4) on a server of lower service pack (like sp1 or sp2). May be I am wrong as I am not sure about it but I didn't faced such issue.

Ziad Iqbal

Hi,

My SQL version says that I have the version Microsoft SQL Server Management Studio 10.50.1600.1
On the other hand when I try to restore it says:
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.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

What can I do to easily solve the problem and restore the DB!!

Thanks