Literally ouch! I suffer from low back pain. For me the thing that keeps me in check is running on an elliptical machine 3-4 times a week. If I maintain that baseline then I normally keep any pain diminished.
I can tell you drinking too much and never exercising does not provide pain relief.