October 30, 2014 at 8:18 am
Restore failed for Server Yadayada. The database was backed up on a server running version 10.00.5500. That version is incompatible with this server, which is running version 10.50.1617.
2008 R2 is backwards compatible with 2008, right? Confused, any help is appreciated!
October 30, 2014 at 8:33 am
I should add that several other db backups from the same 2008 server DID restore fine on the 2008 R2 instance. Could it be one feature in the failing db that needs a different compatibility mode or something?
October 30, 2014 at 8:35 am
I should also add that I know the backup is not corrupt because I am able to restore it on a 10.0.5520 instance.
October 30, 2014 at 10:32 am
That should work. I've never heard about or run into issues restoring an R2 database from a 2008 backup. Just did some searching online. Everything I'm finding suggests it's pretty abnormal. You can't restore an R2 backup to a 2008 server, but since that's not what you're attempting, I'm unsure where the problem lies.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2014 at 10:37 am
Just did a series of searches on both Bing and Google. There is no recorded instance that I can find of this part of the message:
"10.00.5500. That version is incompatible with this server, which is running version 10.50.1617." But if I reverse the numbers, there are tons of hits You may have hit something unique. You might want to open up a support call with Microsoft.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 30, 2014 at 10:41 am
Thanks, I will do that. Nice to know I'm not going crazy.
October 30, 2014 at 11:55 am
Good News…
After installing the Service Pack 2 (SQLServer2008R2SP2-KB2630458-x64-ENU.exe), the issue is resolved.
October 30, 2014 at 1:31 pm
Interesting. Glad you fixed it. Sorry I didn't have anything better to offer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 31, 2014 at 5:14 am
Thanks Grant for your time and hopefully the thread will help others in the future! It's a weird one.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply