March 23, 2012 at 9:10 am
Hello - I am trying to restore a database from a client into our SQL instance but receive an error...
System.Data.SqlClient.SqlError: The database wasbacked up on a server running version 10.50.2500. 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.
I found out this meant that the client was running SQL 2008 R2 while I was running SQL 2008 using RESTORE HEADER on the clients BAK file, viewing the SoftwareVersioMinor, and the info listed here...
http://waynestorey.com/blog/2012/01/15/find-sql-server-version-information-from-a-sql-backup/">
http://waynestorey.com/blog/2012/01/15/find-sql-server-version-information-from-a-sql-backup/
How can I upgrade my version of SQL Server 2008 to SQL Server 2008 R2?
Does my current licensing support this?
I'm new to dealing with version differences, patching, etc so any help is appreciated.
Thanks in advance
Dave
March 23, 2012 at 9:21 am
do you have software assurance with your SQL 2008 licences? if so and it is still valid you can upgrade at no extra cost. if you do not have SA or it has expired you will need to either renew your SA (unsure if you can still do this) or re-purchase SQL 2008 R2 licences
March 23, 2012 at 9:23 am
Hi Dave,
SQL Server 2008 R2 is a newer release of SQL Server - not a service pack or update. It differed in price from SQL Server 2008 as well. For my organization, upgrading to R2 involved $$$ changing hands.
Best of luck!
Bob
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
March 23, 2012 at 9:29 am
Thank you for the quick replies.
Is there a way in R2 to make their backup comapatible with SQL 2008 (that is not R2)?
Thanks
Dave
March 23, 2012 at 9:31 am
Nope, it's a different version of the engine and backups aren't backwards compatible. You can restore a 2008 backup on 2008R2, but not the other way around.
_______________________________________________________________________________________________
Bob Pusateri
Microsoft Certified Master: SQL Server 2008
Blog: The Outer Join[/url]
Twitter: @SQLBob
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply