Wednesday, March 7, 2012

restore a sql server 2005 x64 db backup to sql server 2000 32-bit

When I attempt to restore a db backup from sql server 2005 x64 on my production server to a laptop that has sql server 2000 32-bit, I get a message like "Too many files". And when I go to the tab that let's you change the paths to the db files, the two path fields are blank, when normally they would show some paths.

Is this not possible to do?You cannot take a backup on sql2k5 and restore it to sql2k instance. The metadata has changed significantly in sql2k5 for sql2k to understand.

No comments:

Post a Comment