Posted by Erland Sommarskog on 11/20/07 22:31

time management (tatata9999@gmail.com) writes:
> Thanks for the follow-up, Erland. I tried to attach it with sql
> server 2005 as well, the restored db seemed weired with "D:\aName
> \blakdsm\blad..", empty, not workable. Now, suppose I can get a
> clean/good copy for server 2005, what are the chances of success of
> using DUMB database then BACKUP or LOAD back into server 2000? These
> two boxes are not connected and they can't.

If you need to move a database from SQL 2005 to SQL 2000 you need to
create from scripts and copy data to file with bulk copy. If the database
uses features that do not exist in SQL 2000, you will have to make some
compromises.

You cannot restore a backup from SQL 2005 on SQL 2000. For quite obvious
reasons: there are features in SQl 2005 for which SQL 2000 is not prepared.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]