I am sorry to hear about your problem. At the moment your doctor has started you on the correct regime to help. Back pain can be a problem that can take some time to improve. You should use the medication regularly as directed and try warm massage and hot showers if your muscles feel tight. You should be engaging in light exercise to try to keep things moving. Complete bed rest actually worsen the problem by causing you to stiffen up.
If the pain becomes very bad then we would recommend discussing codeine or tramadol with your doctor, but these not be allowed substances on the base as they will show up in drug testing.
Unfortunately Just Answer cannot write prescriptions for you. If the opain is that bad, then you may need to be given leave for a few weeks however if it continues for a couple of months then you should request a MRI. In a young healthy person, we would normally expect this to settle down before this unless there was a significant injury or trauma.