Never had to do that I wouldn't want to because it cannot guaranty data consistency.
>
>If you copy a database, without detaching, will you be able to attach it? Recently I a customer send me a database and I attached it to my SQL server. All worked. But when I asked him what he did, he said "I just copied the database to CD."
>
>>You can detach database, copy it to the destinaton server and attach it.
>>
>>>
>>>I want to move several databases from a NT 4 machine thats running SQL7 databases to Windows 2000 machine running SQL7.
>>>
>>>Would the easiest way to move the databases be a backup and restore or something like a backup and reattach?
>>>
>>>Please point me to a link to get these instructions.
>>>
--sb--