Dissapearing hdd, bsod and boot failure

[Leonard-t]

Hello! This will need some explaining:

 

For a few years now, my storage hdd would dissapear at random. Removing and reattaching it always solved it.

 

Yesterday i got a bsod while gaming. Restart fixes it for 2 hours. Another bsod and my storage drive is gone and replugging it doesnt work. I test the drive with an external mount and it works.

 

I start swapping cables beetween my boot ssd, storage hdd and dvd reader. Eventually my bios starts resetting itself at random and then i fail to even get to the bios.

 

I remove the hdd entirely and i manage to load windows again but it barely works. I think its a pagefile issue since i had that on my hdd.

 

Apologies for this mess of a post. I am exausted and depressed. Any ideas on what it might be?