Sorry to hear this Pete. I hope you get better very soon. Are you having any treatment / doing any exercises etc? Bloody horrible are shot backs and resulting sciatica etc.
Maybe better to go for the more comfortable hotel option?
Although a few bevvies around the fire will help ease the pain at night.But you'll pay the price in the morning.