Solved

SQL server replacing disks question

Posted on 2015-02-06
8
44 Views
Last Modified: 2016-06-18
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
0
Comment
Question by:dealstrike
  • 3
  • 2
  • 2
8 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 166 total points
ID: 40593732
there should be no special permissions on the files themselves, but only "inherit" from the folder they are in.
so copying back and forth should not result in anything going bad there.
0
 
LVL 34

Assisted Solution

by:johnsone
johnsone earned 334 total points
ID: 40593772
I am by no means an expert on the disk configurations, but why copy the data at all?

Break the mirror, replace 1 mechanical drive with a ssd, sync up the mirror and then repeat for the other drive.

Based on my knowledge that should work, but you should check with your system administrators.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40593795
johnsone, I guess it's in this one:
> I need to upgrade the types of drive of the d drive from sata to ssd <
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 34

Expert Comment

by:johnsone
ID: 40593800
sata is not a type of disk.  It is a protocol over which disks communicate.  The ssd drives are likely sata.
0
 

Author Comment

by:dealstrike
ID: 40593842
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?
0
 
LVL 34

Accepted Solution

by:
johnsone earned 334 total points
ID: 40593918
According to what I know, the raid set would run at the slower speed of the old disks.  Essentially, it will send the write to both and wait for it to finish on both before moving on.  The ssd will be faster so it will just wait.  Once both drives are replaced they should run at the faster speed of the new drives.

You would want to confirm that with your SA and/or enclosure manufacturer.
0
 

Author Comment

by:dealstrike
ID: 40631283
Will let everyone know how it goes on Fri
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question