Brian, a pain in the back is ...well a pain in the back and effects everything you want to do. Like most people my age have had pain along the way. For me when pain such as yours occurs I take a big drink of rum before bed, this makes me fall asleep quickly and once asleep will remain that way most all of the night, pain pills just dull pain a bit for me, I don't smoke so a doob is not the answer for me but helps many people in pain. Hope you can get the issue resolved.
