Please, don't give up. Don't worry about long-term sobriety, just don't drink TODAY. I've been doing that for roughly 7300 days and it's the reason I'm sober. Most of all, look at the reason you picked up after nine months and change your behavior. I can't imagine how awful you feel but you don't have to do it again. At AA get a sponsor and follow his/her advice (my best thinking always got me drunk!).
Always remember: you don't have to drink!!