Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
>>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement