Yes, experience of that! You WILL recover BUT it does take time!
I had it in 08 really bad where I thought I couldn't possibly ride like I used to again, it was quite a stressful time, and VERY painful. I couldn't even sit at the table to have breakfast in the morning (mornings were worse), I had to kneel on the floor and keep my back straight. Anyway, I did ride but only lighty when things allowed. It probably did take almost a year to get back to full recovery. I would say after having on going back problems leading to this for many many years, that now, I feel better than than I have for absolutely years! I raced in 09 (did well)and feel pretty strong now, so you will get there too, just don't over do it at this stage and get some massage, any massage doesn't have to be technical just manipulating the area works as well as a proper physio massage ime.
Btw – I do get some light tingling in my left foot (top) and lower leg for short periods, but it is in no way uncomfortable. Apparently, the sciatic nerve gets 'tethered'after this and provides these sensory feelings for some time. It doesn't bother me at all, in fact I had to edit this, because I only just remembered that.
O, and it didn't make any difference to me, whether I rode full suss or hardtail, as it was a chronic problem and not an accute injury.
All the best mate
Pete