Sql-server – Best way to upgrade Hard Disks holding SQL Data Files

sqlsql serversql-server-2005

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following;

  • Run a backup using Backup Exec on the D:\ Partition (This partition holds the SQL DATA Files)
  • Disable the SQL Services from starting on start-up
  • Reboot the Server into the RAID Controller
  • Remove the old Hard Disks
  • Insert the new Hard Disks
  • Initialize the New Array
  • Boot into the OS
  • Assign the Drive letter D: to the new array
  • Use backup exec to restore all the Data files to the D:\ partition
  • Enable SQL Services on Startup
  • Reboot the server

Is this the best way of doing this? Am I missing something?

Best Answer

If the disks are hot-swappable I would simply replace disk by disk and allow the array to rebuild in this case. You have an entire weekend to do so. You don't mention how big the array is or what type of RAID config you are using but allowing the disks to rebuild is a very simple solution.

You do need to make sure however that your RAID controller supports expanding the RAID volume once the larger disks are in place.

Alternatively what you have mentioned abover should work too, however as I mentioned in the comment above, make sure you run a full SQL backup first, then disable the SQL service, then proceed with the disk backup and go from there.

Related Topic