asked on

SQL server replacing disks question

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.

Thanks

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Guy Hengel [angelIII / a3]

johnsone, I guess it's in this one:
> I need to upgrade the types of drive of the d drive from sata to ssd <

johnsone

sata is not a type of disk. It is a protocol over which disks communicate. The ssd drives are likely sata.

s a

ASKER

Correct, but while the existing 7200rpm disks that hold the D: are 1TB and so are the new SSDs, they are different models completely (old: intel, new: micron)...so I dont think breaking the raid and installing the new one will work?

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

s a

ASKER

Will let everyone know how it goes on Fri