ASUS P5QL Mobo dosent see my HDD

So like the title says, my asus motherboard does not see my sata hard drive. This problem probably came from another, so here is the story. A few days ago I misclicked when turning off my computer and accidentally put it in sleep. Just after misclicking I tried to wake it back up to turn off. When clicking didn't do anything I reached over to click the power button, and nothing happened. I killed power and then tuned it back on only to find that it was stuck in sleep mode or something like that. After checking my connections and looking at some forums I decided the only way to wake my computer back up was to take out the motherboard battery and put it back in. (I am not sure if that was a good idea, but at the time I was happy that it worked.) After booting back in I restarted and it worked again. (After fixing the first problem I successfully booted two times) A few hours later I turned off my computer for the night. (Note: There were windows updates when I turned it off, so I started them at turned off my screen and heard my computer shut down 30 minutes later) When turning my computer on the next day it said to insert boot media and click a key, so I restarted and went into the bios. It turns out that my bios does not recognize my sata hard drive (seagate 500g). I have updated my bios to the latest version and it still does not work. I have checked my wiring and the hard drive is powered on and connected. The front panel of the computer even reads that the hard drive is connected.
I included the long version just in case any of it helps, for I have no idea what the problem is. At first I thought an old bios was not compadable with my processor, but I flashed the bios to the newest version. I already posted the problem in a response to a thread with a similar problem, but I thought it would be better to make my own topic with this problem. Any suggestions would be much appreciated. Thanks!

Specs - ASUS P5QL Mobo, Intel q9550, Seagate 500g HDD, 2 gigs Crosair ddr2 ram, cooler master 430w psu, 3870 gpu (for fear that a lack of power is the problem I put my old x850xt in) .. and thats all that should really have any impact.