Creating a Backup Schedule
You know how to schedule backups of transaction logs and databases, but when should you back them up? To answer that question, you are going to create two separate categories: Category 1 consists of actions performed in a database that warrant an immediate database backup. Category 2 consists of scheduling backups that meet your restore needs.
Category 1: Actions that Warrant Dumping a Database
In general, you are aware that you should perform database backups on a timely schedule. Backups should also be performed after certain actions occur in a database to ensure full and easy restores.
After you perform certain actions on a user database, you should back up the database as soon as possible to guarantee ...