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 |
|
zakwithu
Starting Member
8 Posts |
 Posted - 2009-10-06 : 06:30:59
|
| Hi SQLteam,I'm running sql server enterprise 2000 on win2k3 sp1. The database file is devided into four data files. one primary with extension (.mdf) and the other three secondary files are having extension (.ndf)The problem:the first two files are located in drive D: and the other located in different folder in drive E:what is the best practise to put all files together in one location (folder)?thank you,Zak |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-06 : 08:01:40
|
My first thought is do a backup and then restore with providing needed drive/path/name.But maybe some of the real GURU's are knowing other ways.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2009-10-07 : 12:05:57
|
| The reason data files are spread across different drives is to spread I/O across different drives. You shouldn't not be putting everything in same drives. Tell us the exact reason why you are doing this. |
|
|
|
zakwithu
Starting Member
8 Posts |
Posted - 2009-10-07 : 15:02:23
|
| moving this file from drive D to drive E will simply free some disk spaces. |
|
|
|
|
|
|
How to change data files