No, a bad alternator will not drain your battery when the car is off. If your battery is draining when the car is off, it is more likely a problem with an electrical consumer such as the car stereo, door lock or door switch.