Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to move database
Message
De
25/03/2001 19:31:46
 
 
À
23/03/2001 13:21:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00487960
Message ID:
00488461
Vues:
8
>>>Hi,
>>>
>>>What is the best/preferred/proper way to move a database (the physical files) to a new drive or location?
>>>
>>>TIA,
>>
>>Ken,
>>
>>Look at the "Attaching and Detaching Databases" topic in the SQL Books On Line. They tell you how to do this.
>>
>>BOb
>
>thanks Bob - that's what we've been doing - didn't know if that was best way

You can also use backup/restore, but we use the to duplicate a database on another server. We do this to take our development master to our personal server to work with.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform