I can sympathise Steve, and sorry for the late response.
You might not be surprised to know that nearly 3/4 people do experience back pain ( and 2/3 neck pain) at some time in their lives. It's most common between 35 and 55, and less than 1/10 go on to become chronic (lasting over 12 weeks). In most cases it's "non-specific" - brought on by twisting, heavy physical work, prolonged static postures like sitting at the computer, or stress and anxiety. Less than 1/20 have a physical cause like prolapsed disc, fracture, or arthritis.
Opioid painkillers such as Tramadol, or non-steroidal anti-inflammatory drugs such as Ibuprofen, are beneficial for severe pain. Massage, or various other "treatments" suggested already may help possibly because they also help relaxation, which is so important. Prolonged bed rest, or traction, is not recommended. Lumbar supports, spinal manipulation and acupuncture, are of uncertain benefit. Moderate exercise is encouraged as soon as possible.