SQL server replacing disks question
Posted on 2015-02-06
Hi, on our database server we have a c drive (OS), D drive (databases), E drive (logs),
The C drive is on a ssd raid1, D drive on Sata raid 1, E drive on ssd raid 1, so each drive has their own disks on the raid controller.
I need to upgrade the types of drive of the d drive from sata to ssd, so during downtime I plan on stopping the sql services of the server to prevent read write and then copy the contents of the d drive to an external hard drive (copy and paste) , and then replace the drives, and then copy the contents back (copy and paste back).
Will it copy the permissions and folder properties of the d drive to the external hard drive and back? Is there anything else I need to worry about or do to make sure this works and goes smoothly from the sql/Windows server side? The raid side?
Some step by step would be nice, thanks.