Windows Server Disappearing Drive Issue

We have Windows Server 2019 installed on a latest generation Dell Optiplex.  (We needed server OS capabilities without the server hardware.)  

The machine has a SSD on SATA0 and HDD on SATA1.  They are both installed at the factory by Dell.  The SSD has the OS and HDD has the data storage.  No RAID.  Drives connected to board.

The installation completes without an issue.  We double check the BIOS and drivers from the Dell website and update.  The machine is setup and placed into service without issue.

After a few days, we find that the HDD is not showing up in Windows nor Disk Management.  We are of course shocked and reboot into BIOS.  The drive is showing fine.  We have enabled to report SMART error reporting.  It physically seems to be fine (not hot, making noise, et cetera).  

We return to Windows Server 2019 OS and the drive is back and working like nothing happened?

This has now happened twice -- the drive disappears out of the blue in the OS and a reboot makes it reappear.  

I'd be more than happy to replace the drive, but is it the drive?  OS?  Board?  SATA Port?  Other?
Brad McAfeeAsked:
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.

David Johnson, CDRetiredCommented:
If under warranty have dell replace the entire unit
JohnBusiness Consultant (Owner)Commented:
Good advice above.  Also consider that workstation BIOS may possibly not be compatible with Server 2019.
andyalderCommented:
Have you tried reseating the cables between drive and motherboard?

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
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Philip ElderTechnical Architect - HA/Compute/StorageCommented:
Curiosity question: What's the PC being used for?

Is uEFI set up in the BIOS along with SecureBoot?
The OS and the data drive should be set up as GPT. Are they?

Dell has a habit of delivering PCs with the BIOS setting for the SATA ports at RAID. Flip it to AHCI. If this is the case a re-install of the OS will be required or there are blog posts out there that explain how to flip an existing OS from the RAID setup to AHCI if there is a desire to preserve the already installed OS.
nobusCommented:
check also if that drive is not set to conserve power  - and gets inactive
Brad McAfeeAuthor Commented:
Nobus: All power saving is disabled.
Brad McAfeeAuthor Commented:
Phillip: What is the best way to check UEFI/SecureBook and GPT settings?
Brad McAfeeAuthor Commented:
andyalder: Yes I have tried that but I am going to try to move it to a different SATA port later this morning and will report what happens!
nobusCommented:
then test with other cables and ports
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.