Secondery hard drive doesnt show up on file manager

I would make it a priority to get another copy of the data, then check drive health and look for firmware updates (both for the system UEFI/BIOS) and the drive. Some drive vendors provide diagnostic tools.