Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wbb1975
Starting Member
23 Posts |
 Posted - 2004-05-25 : 05:11:05
|
| Hi,how can I change the location of the data-files in SQL-Server 2000 (we would like to move all data-files and the default location for all data-files on a separate disc ...).Thanks in advance for your answers!GreetingsStefan |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-25 : 05:32:02
|
| You can do a backup and restore with move or you can use sp_detach_db and then sp_attach_db... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-05-25 : 06:04:24
|
| You might want to chagne the DEFAULT location for New databases too (I think you can do this in Enterprise Manager - Right click the Server and then choose PROPERTIES)Kristen |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
|
|
|
|
|
Changing Location of data-files