• If you're only doing a nightly update, I agree with the recommendation to use a simple backup.

    I have several updates throughout the day, however, so I make a full backup and take a transaction log backup when each of the updates during the day are complete. That way I can restore to the point to match the audit information that gets stored.