I have a MS SQL server with separate system, data and log drives. My data drive is getting tight on space, so I added a new drive to the server. Now I need to know how to add the new drive to SQL server so it can be used, and move some databases to it. How do I accomplish this?
If youhave HW Raid controller, you need to first backup the data just in case, you then need to look whether the RAID group that makes up the ... Is expandable online.
If you have software based RAId, you would need to use the disk management interface to add the drive into the group.
MAKE SURE YOU Have good backups prior to make any attempts.