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 |
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
 Posted - 2007-01-17 : 18:44:15
|
| We are adding some more drives to our server so we can have a more ideal setup for our SQL server.We are going to add two more arrays: a RAID 0+1 for data files and a RAID 1 for transaction log files.My question is, what is the correct way to move the files to the new arrays?I've been reading BoL, but wanted to ask those who have done it before if there are any caveats that I should be aware of or potential pitfalls?That is pretty much it.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
Posted - 2007-01-18 : 11:18:27
|
| If I just wanted to move one specific DB I created, I could use the same instructions? I don't need to move everythign else, unless I wanted to? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-18 : 12:15:51
|
| Yes you can use the same instructions.Tara Kizer |
|
|
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
Posted - 2007-01-18 : 17:31:11
|
| One thing I forgot, but the directions above are probably similar.But, I am going to split the tlogs and data files and put them on different arrays. Would I just move the corresponding files to their location, then specify the file location in SQL analyzer?Do maybe th data is on F: and the tlogs are on Z:Just make sure that is correct in the query? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-18 : 17:33:43
|
| Yes and yes.Tara Kizer |
|
|
|
|
|
|
Moving data and log files