I have had L5S1 herniation's (4) and I have found 3 positions that work for me. 1) on side, with hurt leg on top on a pillow(between legs) knees slightly bent. 2) On back with pillows under knees so that back is flat. 3) on stomach but with no pillow at head, and 2 pillows at hips/thighs. I have found when the nerve is really fired up it may take up to 20-30 minutes in one position until your body relaxes enough to be comfortable to sleep. Hope this helps.
I had shots and it would take up to 1-2 weeks before the full effect took place, and sometimes it hurts as the meds go into your disc area, like a throbbing as it moves into where it needs to go. The second shot may help because it joins with the first to help your problem. The angle of the shot may also help, my dr did one sideways(like sniper) instead of the traditional up from the bottom. Each person is different, the side approach worked for me.
Good luck, be encouraged, back pain is not something you would wish on anyone.
I found that sleep in on my stomach, with my hurt leg bent and my body semi curled up is the best way for me to deal with this pain. I've had this issue for 16 years now and I have tried everything. I don't like having anything between my legs, and when I do, it actually puts more pressure on my nerve...causing more pain. I hope you find some relief. I am now at the point of looking into disc replacement....so trust me, I know your pain.