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 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2007-05-22 : 12:14:23
|
| I am working with a client who has all databases, logs, tempdb and user/system databases on a single raid set.In order to make some speed improvement, we have decided to move log files to a second raid controller card.To accomplish this, we are thinking about taking these steps:1) Detach database XYZ.2) Stop database service.3) Create a new partition on new controller card.4) Copy old log files from I: to new K: drive.5) Remove drive letter I: from system.6) Change drive letter K: to I:7) Attach databaseMy question is, does SQL Server recognize the log files automatically, since they are placed at same logical position (i: drive)?Peter LarssonHelsingborg, Sweden |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-22 : 12:19:10
|
| You can specify new log file path when attach the db. By the way, don't need stop sql service since dbs are detached. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-05-22 : 12:36:39
|
| Ok.But the log file path would be the same after attach, since we change the drive letter to i:as the old path was.Peter LarssonHelsingborg, Sweden |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-22 : 13:02:37
|
If you are going to stop the SQL Server Service anyway you can probably do this without Detach / re-Attach  You'll have a Backup anyway, in case anything goes wrong ...Kristen |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-22 : 13:27:09
|
| Kristen is correct. You don't need to detach/attach when the path will not change. You just need to make sure the service is stopped while you make the config changes.We've done this probably 20 times. On one of our SANs, we weren't able to expand the drives dynamically, so this is the way we did it when we ran out of disk space. It required us presenting new disks to a new drive, then copying the data to the new drive, deleting the old drive, then renaming the new drive. This is in essence the same thing.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-05-22 : 15:48:39
|
| Thanks all!Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Need confirmation