Based on ur description . It looks like sciatica. When the pain is relieved with medication it might be mild.
If you have muscle weakness on affected side then further stepping up of treatment needed.
Get an MRI for details.
Next Steps
MRI
Health Tips
Use firm mattress for sleeping, physiotherapy for back muscle strengthening when pain free. Use ice packs for pain.