September 17, 2008 at 9:29 pm
I know it is ok to restore a db from 2000 to 2005 but is it ok to do it the other way?
September 17, 2008 at 10:03 pm
No. There are differences in the way that SQL 2005 stores data that make restoring to an earlier version impossible. When you restore a SQL 2000 database to SQL 2005, changes are made during the restore process. And during the normal insert/update/delete operations, the way data is stored may be updated as well.
If you have a need to restore data to SQL 2000, you will need to use something like DTS/SSIS
September 30, 2008 at 3:57 am
If you query master..sysdatabases, you'll see a column called version. This column represents the internal databasestructure.
This number is higher for 2005, compared to 2000 (generally, every new MSSQL version has a new databasestructure)
Upgrading is not the problem, because a SQL2000 database will be automatically upgraded to the 2005 structure (check the column).
SQL2000 doesn't know the 2005 structure, it doesn't know how the interpret the structure. So a downgrade is not possible.
Compatibility (another column) has nothing to do with the databasestructure, but determines how SQL behaves for that database.
Wilfred
The best things in life are the simple things
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply