Sleeping on the back can cause the lower back to arch. Sleeping on the stomach can push the hips back, leading again to curvature of the lower back. All of this stress on the spine and surrounding muscles can lead to tightness and pain upon waking up or even during the night.