It's also worth the effort to stop users using the database whilst you are making the changes if you can.

If you do have to restore using the backup you've taken and there were users processing data then what happens to their data?