Earlier, I stated that the
Back Up Database (Full) task is the most important maintenance task for DBAs to implement. Now we have come to the second most important task, the backing up of transaction logs, which is implemented using the
Back Up Database Transaction Log) task.
In order to recover as much data as possible after the loss of a database, and to enable point-in-time recovery of your data, when using the full (or bulk-logged) recovery model, it is essential that you perform regular transaction log backups in addition to full backups (Chapter 12), and possibly differential backups (Chapter 13). The
Back Up Database(Transaction Log) task allows you to schedule the backup of your transaction ...