Unsolved
This post is more than 5 years old
12 Posts
0
690
August 10th, 2011 02:00
Does migrating a LUN change the Server Drive Letter?
Hello all..
I've got several SQL server partitions that I need to increase the disk space for. From what I'm reading I should probably do the migration option because I'm basically tripling the space with larger drives (same speed though) and I understand I can migrate without any server downtime. My only concern about migration is if that changes the drive letter from the server's prepective. I wouldn't think so but figured I'd ask to be safe.
thoughts or opinions?
Feel free to point me to another post or doc that I may over looked.
Thanks,
Bob
BTW, I have an EMC CX3-10c, just in case that matters..
No Events found!
dynamox
11 Legend
•
20.4K Posts
•
87.4K Points
0
August 10th, 2011 04:00
Bob,
server will not notice a thing, LUN Migration happens on the array, as a background task. LUN #/name will remain identical, you can tweak priority of migration speed if you like by setting high,asap,low.
DanJost
190 Posts
0
August 10th, 2011 07:00
The short answer on the drive letter is "no" and other than increased disk activity during the migration the server won't even notice it happened. If you are increasing the size of the LUN you'll have to increase it in the OS. For Windows 2008 R2 (I skipped non-R2 so it may apply there) this isn't a problem. Previous versions of windows require additional gyrations for the space to be useable.
I always take the time when I am creating "bigger" disks to double check alignment and NTFS settings. If it could use a little tweaking, this would be a good time to manually move it to a bigger disk that is formatted optimally. When SQL is offline you can just change the drive letters around to match the original disk and when you bring it up it's fat dumb and happy. It's a little dicier with a cluster but not overly heinous if that is your setup. There are plenty of articles on technet and elsewhere that will point you in the right direction for optimal settings. While I've seen some people tweak themselves to death, tweaking the storage for SQL server is a known quantity and really shouldn't be overlooked.
Dan