Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving (or copying) a database from one server to anothe
Message
De
01/10/2002 18:18:42
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00706195
Message ID:
00706618
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform