restoration of DB from sql 2005 to sql 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

restoration of DB from sql 2005 to sql 2000

Can I restore a backup of a database from SQL 2005 (Beta version) to SQL 2000 I am getting error no. 3169 Regards
Riya Riya
I think it is not possible Madhivanan Failing to plan is Planning to fail
No. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Hi, It is possible. I have tried this scenario on another machine.
It gets restored. Let put my problem in right words… "The backed up database has on-disk structure version 587. The server supports version 539 and cannot restore or update this database RESTORE FILELIST is terminating abnormally" Regards Riya
Hi,<br />thankx for sharing it with us .<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
quote:"The backed up database has on-disk structure version 587. The server supports version 539 and cannot restore or update this database RESTORE FILELIST is terminating abnormally"
So Restore failed? Madhivanan Failing to plan is Planning to fail
Yes whenever I click on the OK button for restore it gives that error. Regards
Riya
>>Yes whenever I click on the OK button for restore it gives that error. Then what do you mean by this?

It is possible. I have tried this scenario on another machine.
It gets restored.
Madhivanan Failing to plan is Planning to fail
What scenario have you tried on other machines?
To the best of my knowledge it is neither possible to backup and restore, nor to detach and attach a 2005 database to a 2000 server. The 2005 file format is not compatible with 2000.
The only way would be to use DTS or Integration Services. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

You cannot restore the SQL 2005 to SQL 2000, as it is invalid option to use the high-end database in lower end version of SQL. I agree with Frank to transfer the data in that manner, than using BACKUP & RESTORE compatbility. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>