>I am aware of that. But how exactly do I use it to move the database? I've tried creating a backup in 7.0 but when I try to restore it in 9.0 I receive a message that it can't be restored because it was created in an earlier version.
>
>I tried to detach the database and copy the files but the transfer would take over 4 hours. And I might still run into the same version problems.
>
>Is it possible to move 7.0 database to SQL Server 2005?
There's Copy Database Wizard in SSMS that allows to copy SQL 7/2000 DB to SQL 2005.
--sb--