The problem: I performed the backup of the source database from the enterprise manager of the target server (machine). The program said that backup would be made to c:\MSSQL7\backup\name, but it was refering to c: of source machine, I guess because it was the source server talking through Enterprise Manager.

I the tried manually copying the file to c:\MSSQL7\Backup of the target machine and performing a restore from device indicating the copied file as the device, but couldn't fool the system.

Suggestions?

Thanks again.

Alex

>If you open into Enterprise Manager, and click on "Databases", right-click it and you will find "Restore database..." under "All tasks".
>
>
>>Thanks for your help. I did the backup of the original database fine.
>>
>>What next? To add it to the second server I created an empty db with desired name, but can't see how to restore it with backup.
>>
>>Alex
>>
>>
>>>You have many ways. The fastest is normally a backup-restore operation.
>>>
>>>Other than this, you have DTS which is available from Entreprise manager (tools -> export data).
>>>
>>>>I have two machines set up as MSDE 7.0 servers. How do I move (or copy) a database from one to the other?
>>>>
>>>>TIA,
>>>>
>>>>Alex