November 7, 2011 at 5:28 am
when i try to restore the database it unable to restore because of the versoning problem.
The below error comes.
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.2573. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
please help how to restore that database.
Thanks in advanced.
November 7, 2011 at 5:31 am
You can't take a backup from 2k8 R2 and restore it on sql 2k8.
Restores have never worked downwards and they never will.
You either have to restore on the same version or script everything and rebuild the db that way.
November 7, 2011 at 5:56 am
Thanks for replay SSCoach
if you don't mind would you please tell me the script to rebuild the db
November 7, 2011 at 6:00 am
I've never done it personally. In SSIS there's an import DB task that does this.
That's the best I can give you.
November 7, 2011 at 6:12 am
There's no magic script.
Use SSIS's tasks or do it manually - script all objects, bcp out all data, recreate the DB on the lower version.
Or upgrade the instance you're restoring onto to SQL 2008 R2.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 7, 2011 at 10:51 am
You can do this via SSIS or Jonathan Kehayias showed how to this directly through SMO. I'll see if i can find the link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply