April 5, 2010 at 3:47 pm
Hello Everyone
I am trying to restore a SQL 2000 database. Yes, I know this is a SQL 2005 section. I connect to the database using SSMS for everything except when working with DTS, then I use EM. I am only wanting to restore this database so that I can work on it at home as well as in the office.
The error that I am receiving is this
"The Backed-up database has an on disk structure version 611. The serversupports version 539 and cannot restore or upgrade this database."
I receive the same error weather I use EM or SSMS to try and restore.
Any clue as to what the problem may be?
Thanks in advance
Andrew SQLDBA
April 5, 2010 at 4:49 pm
It appears that you are going the wrong direction with that. You have a SQL 2005 database trying to restore to a SQL 2000 Instance - not possible.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2010 at 4:56 pm
I agree with Jason, that is not a SQL2000 backup you are trying to restore, as shown by the version nos in the error message.
Its telling you this backup is too high a version to be restored to this SQL instance.
---------------------------------------------------------------------
April 6, 2010 at 6:12 am
Actually, it is a SQL 2000 database that I took the backup using SSMS, instead of SQL EM. I would not have thought it would have made a difference, but it does. I used SQL EM, took a full backup and it works fine to restore.
Thanks for the advice and info
Andrew SQLDBA
April 6, 2010 at 6:20 am
Most Odd.
What is the value of the database_version column in msdb..backupset for each of these backups you are trying to restore?
---------------------------------------------------------------------
April 6, 2010 at 9:58 am
I would have to agree that that seems odd.
My expectation then would be that SSMS is altering the DB backup somehow to append the 2005 db version.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 11:16 am
i think i've seen this before, where version 539 is not a release-to-market version of SQL , but one of the preview versions.
I had that issue where i could not restore a production db, because i was not running an RTM version.
ended up having to install a non-preview versiomn to restore it.
Lowell
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply