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 |
chedderslam
Posting Yak Master
223 Posts |
Posted - 2010-02-16 : 10:13:11
|
How do I move the db files to another disk?I need to free up space on my c drive and want to move the dbs to d:. ?How do I do this. I would like to do this for all dbs, including master. There are only a few so I can do it one by one if need be, no need for a script or anything.Thanks. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-02-16 : 16:35:17
|
for user databases, detach/attach or backup/restore method. For system databases search "how to move sql server system databases" |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|