I've got scoliosis which has caused all sorts of disc problems, also IBS and stomach surgery which limits my choices of NSAIDS. My worst pain is lumbar, but I have problems in thoracic and cervical spine also.
If your problem is mainly muscle tension, spasms:
There ARE a whole lot of NSAIDS, some that are not supposed to upset the stomach, some in creams or patches. The OTC ones are useless. I had no luck with piroxicam, but Mobic by mouth works for about 4 hours. I had no luck with Voltaren gel. Lidocaine patch didn't work either.
Muscle relaxants may help too. I haven't had any luck so far with any except diazepam, but since it's a benzo, I don't want to use it regularly and get addicted. It's nice to have on hand for emergencies though.
I also use a TENS unit. Your insurance will probably pay if you've tried other things first. Alternately, they're available online, not horribly expensive. I use mine when I have to drive or sit a long time. When I get home I don't need the heating pad.
If you have mainly pinched nerves, you might want to see a pain doc about getting steroid injections. Get a referral from your orthopod. Not all of them do injections, so ask what the ones you call or get recommended do. I've had some that worked for a long time, some that didn't work at all. I liked the epidural in the L5-S1 and the one in the tail bone that hit all the nerves going down as well as going up some into the spine.
With scoliosis, I happened to see a Phys Therapist who informed me after testing that one leg is a little shorter than the other. This is often the case with scoliosis. I needed arch supports, saw a podiatrist who fixed me up with a tiny lift and wedges to throw my feet to the outside as well as arch supports. This has helped my back!
I can't take Percocet unless I take Zofran with it. I take tramadol, which helps, but isn't realy enough, especially since my pain doc only lets me have 3 a day and they only last 4 hours.