If this is production AND you have a backup, you may not want to restore over the top of a production database. you can instead restore to a new database, then add the column allowing nulls, use an update query to put the data back leaving anything in the other columns unchanged. depends on the nature of your data and environment.