General information
Forum:
Microsoft SQL Server
Category:
Database management
>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only