Bypass Server 2016 2TB Limit

We are setting up a new sql server in our office.  It is a Dell PE R440 w/ 32GB RAM and 4 Hot Swap 3.5" drive bays.  We have four SATA 2TB drives in each bay.  The system has a PERC H730 controller for RAID.  We configured a RAID 5 (3+1) with the last drive being designated as the Hot Spare.  The RAID configure without issue, just a little overhead which brought down the over volume size to just under 4TB.  We are using Windows 2016 Standard Edition.  We boot of the disk and start the install.  The problem is that when it comes to choosing the drive to install too, it shows two Drive 0 drives in the install.  One is 2048GB and the other is 1677GB.  I am assuming that is is due too a 2TB limit but Im not sure.  I know there is a way for the system to recognize the full 4TB but I have not been able to find that information out.  We upgrade the System BIOS to the newest version but still the same issue.  Could us some help on this one as we do not want to setup two separate drives for this server.
Ray McGowanConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray McGowanConsultantAuthor Commented:
We ran the server install troubleshooter and was able to get to a command prompt.  Ran Diskpart and updated the partition to gpt. Then reran the install and the partition showed as 4TB. Problem is that after the install when I open the Drive icon on the desktop it still only shows a 2TB partition...
0
CompProbSolvCommented:
If you go into disk manager, can you expand the partition beyond 2T.

As an aside, RAID 5 is generally to be avoided these days.  Yes, it's more efficient in the use of space, but the risks are greater.
0
andyalderCommented:
RAID 5 plus a hot spare Vs RAID 6? Both lose two disks worth of space to redundancy but only one survives if two disks fail simultaneously.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

kevinhsiehCommented:
You should be running this as a virtual machine, so install on Hyper-V or vSphere hypervisor. Your Windows Standard license will allow you to run 2 Windows Server VMs with your license on the same hardware. Very, very rarely should any workload go onto bare metal these days, and SQL is not ever one of them.

You have slow disks to begin with, don't make that worse by using RAID 5 with a hot spare. Use RAID 10. Same usable capacity, it can survive 1 maybe 2 drive failures, is much much faster than RAID 5 in terms of writes and to a lesser degree reads. RAID 5 is not recommended for hard disk drives 1 TB or larger in size due to Unrecoverable Read Errors possibly causing the entire array to be unrecoverable if a drive fails. RAID 5 is fine for SSD.

Your overall design of installation on bare metal with RAID 5 and a hot spare is straight out of 2005. The RAID 5 isn't safe at that drive size, and the hot spare is much more useful in RAID 10. Microsoft virtualization benefits give you a second VM for "free", and VM migration to new hardware and overall backup and recovery is much simpler than traditional Windows on bare metal.
1
David Johnson, CD, MVPOwnerCommented:
If you had used the EFI boot in the first place (requires you to select the boot device as you will see 2 entries for the same device) it would have installed correctly into a gpt partition. If I was you I'd start over again.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
McKnifeCommented:
David is correct. But if you simply start over, partitioning will not change (as it is already formatted, if I get you correctly). So you will have to boot setup in uefi mode, then, when at the language selection screen, press shift F10 to bring up the command prompt and there reset disk layout with these commands (execute them one after the other):
diskpart
list disk
select disk x (x is usually 0)
clean

Open in new window

Then, close the command prompt and go on with setup.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2016

From novice to tech pro — start learning today.