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