The back surgery itself should not be painful as you should be put under anesthesia or given something else to numb the pain where the incision is made for the back surgery.
After back surgery you may or may not experience a bit of pain as you recover from the back surgery but the pain should go away after a few weeks.
Although most times back surgery is pretty successful there are times where back surgery has made peoples back pain worse.