Expand data partition

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  January 30, 2006 at 3:42 pm

  #170313

  Hi Guys,

  One of my SQL Servers is running on a Raid 5 and the disk has many partitions.  The data partition on that server is running low on space.   I have several other unused partitions that are not being used.  Here is what I was thinking of doing to resolve this problem. 

  1. Put up a maintainance window and bring down SQL Server

  2. Change Disk from Basic to Dymanic

  3.  Delete the Unused partitions.

  4.  Add those partitions to data volume to increase it

  5.  Start up SQL Server and related services

   

  I have not done this before - so any advice or warning would be much appreciated. Note:  Data partition is not on the system partition.  System partition will not be touched. 

   

  Thanks

  Vik.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  January 30, 2006 at 7:03 pm

  #617865

  I think this will work and not a big deal since you are all on a single RAID 5 partition.

  Might see some perfromance issues if the partitions are separated.

  I guess there's no chance of a disk reformat to rebuild partitions?

• rahul marathe

  SSC Rookie

  Points: 47

  More actions

  January 31, 2006 at 7:08 am

  #617919

  Well you can always increase the disk space.

  But why not keep the unused partions as they are

  create filegroups on those unused partitions and move some table on to filegroups

• Vik Nat

  Hall of Fame

  Points: 3930

  More actions

  January 31, 2006 at 7:26 am

  #617925

  Hi Guys,

  Steve, I could switch traffic to the standby DB and rebuild this server - but for now I think I will just go with expanding the partition. 

  Rahul, I had considered additional filegroups but figured freeing up and using unsed partitions was the easiest way to go for now.

  Thanks again for all your help.

  Vik