Lower back pain is typically caused by our daily activities.
Normal habits and movements can put undue stress on the muscles in your back straining them to the point where they cause you pain.
It helps if you exercise your core, sleep on a supportive mattress, stretch before bed, carefully get out of bed and sleep in the right position.
There really is no manual given to us that teaches how to hack the sleep position that is most comfortable for you.