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?