August 1, 2006 at 3:10 pm
Has anyone ever been sucessfull at restoring a SQL2005 database to SQL2000? I've gone the other way several times with no hitches, but hit a snag trying to go the other way.
Even though I have the Compatibility level set to 80 (SQL Server 2000) on the SQLServer 2005, I get the following error message when I try to do a restore:
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
I finally gave up and just restored it to 2005, but we would like to move it to 2000 if possible.
Thanks,
Jason
The Redneck DBA
August 2, 2006 at 3:18 am
not tried but I'd suspect it won't work - you could try an attach and detach
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 2, 2006 at 6:18 am
Databases are not backward compatible even with the compatibility set to 2000. If you really have a need to do this you will have to script out the DDL and then transfer the data via Int. Services...
August 2, 2006 at 6:27 am
Thanks for the advice. I used the export wizard and sucessfully moved the database last night.
The Redneck DBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply