Thanks Bob, especially for the second nugget! That was really bothering me (that 'files' seemed to just disappear).

I think I have a reasonable chance to get done what is needed now.

Cheers,

JimN

>Hi Jim,
>
>John has an excellent suggestion in using DTS to move your databases, but you can also do it manually if you don't have access to DTS. Take a look in SQL Books on Line under "Attaching and Detaching Databases". What you basically do is detach the database from the server using stored procedure sp_detach_db, copy the database and log files to the new server, and the attach them using sp_attach_db.
>
>It has been a while, but I remember trying this (successfully) when MSDE first came out just to make sure it would work.