These days I have a rare spinal condition that limits me to lifting 25lbs Max, so I've had to exercise differently, I run and cycle (cycled for years) and have started Pilate's, the Pilate's made a massive difference to quality of life, its amazing how back pain over a long period causes postural changes your arent aware off as you instinctively restrict your own motion to minimise pain.
I've had two periods of my life where I've been free from back problems for extended periods. The first was when I was doing aikido. There was some minimal warm up stretching, but the main thing was that practice involved a lot of range of motion. Despite seemingly bad things like awkward positions and getting thrown and hitting the ground hard, I had no back problems at all during that time. The second time was when I was lifting free weights. Squats and deadlifts (done correctly) strengthen the support infrastructure for the back (and everything else). During both of those regimens I also lost a fair amount of fat. (I actually gained weight while lifting but my wife remarked that I looked thinner).
I think that many kinds of exercise could have similar effects. Yoga, anyone? Maybe Tai Chi? Man, I need to get back to doing something regularly again!
I assume it varies from person-to-person, but is there some kind of rule-of-thumb for what rate to increase your weights?
That said, I'm a big fan of the Greyskull program. You increase the weight 2.5 - 5 lbs per session (provided you hit the goals of your previous session).
I began deadlifting twice a week, and within two weeks my back pain significantly reduced, and within six weeks my back had healed completely. I also felt much less back discomfort or pain from activities that would previous cause discomfort or pain in my lower back (e.g., sleeping on my stomach).
I think everyone (women included) who is physically able to should lift weights regularly. Not only for the primary benefits of getting stronger and looking better, but for all the passive secondary benefits that come with it: improved posture, permanently increased metabolism (6-10 calories per day per pound of muscle), reduced risks of osteoporosis, reduced likelihood of injury, etc.
The important thing is to lift consistently, heavy, and progressively lift heavier. It can be pretty intimidating for someone who hasn't done it before, so I recommend a routine like StrongLifts 5x5 or Phrak's variant of Greyskull LP to start. /r/fitness has lots of good info in its wiki.