Id try not to see it as a "failure"....try and see it as a lesson.
What did you learn about alcohol, social situations, and where you are at in your recovery right now? How can this information help you in the future?
I think we have all been there Krys.