Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to move database
Message
From
25/03/2001 19:31:46
 
 
To
23/03/2001 13:21:31
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00487960
Message ID:
00488461
Views:
9
>>>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
Map
View

Click here to load this message in the networking platform