HealthCast

With a maintenance plan, SQL Server^® can automatically perform functions such as checking database integrity and performing database backups. Two maintenance plans are needed to schedule both Full and Transaction Log backups.

Full Database Backup Plan

Create a maintenance plan to perform a full database backup with a recurring schedule (recommended once per week). Each of the following server services require database access and should be included in the maintenance plan:

Transaction Log Backup Plan

Create a maintenance plan that will perform transaction log backups once per hour or at a frequency that fits your database recovery needs. Backing up the transaction log saves transactions that occur in between full database backups and will allow you to recover data up to the moment of the last transaction log backup. Scheduling these to occur more frequently may reduce data loss in the event of a failure.