Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving (or copying) a database from one server to anothe
Message
From
01/10/2002 18:18:42
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00706195
Message ID:
00706618
Views:
13
I fooled around with it for a while and finally got it. Thanks for the help.

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
Previous
Reply
Map
View

Click here to load this message in the networking platform