Okay,
It might just be a glitch with the HDD because I would expect you to get a log for a "HDD Error" if it was faulty or had completely failed.
Maybe first try the "Repair Database" option, as you will see from your previous image, the warning states that doing this won't destroy any footage on the HDD. Try this and see if this repairs the glitch that is stopping you from accessing footage.