Saturday, February 25, 2012

Restore a database from Yukon to SQL 2000 SP4 edition?

Hello,
I have a siuation that need restore a testing database that currently running on Yukon server to SQL 2000 SP4 staging server. I am getting an error when I go with filelistonly option to see if its possible.
### Error Starts ###
Server: Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 603. The server supports version 539 and cannot restore or upgrade this database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
### Error Ends ###

Yes, I am trying to downgrade it, any way that I can do?

Thanks in advance.

Sunny Jung

Sunny,

There is no way to downgrade. You can try to export the data and them import it. But this isn't a scenario we test.

Dan

No comments:

Post a Comment