Assigning or removing a legacy SQL backup schedule

When the task of creating the backup schedule has been completed, assign it to a database. Assign either a user-defined backup schedule to the database or a default schedule profile. The SQL Server agent limits only one profile per database at a given time. Multiple databases cannot be scheduled to the same profile at one time. However, the same backup schedule can be assigned to multiple databases individually.

Click Remove to delete already assigned profiles. Clicking Remove deletes the backup schedule’s association to the database and removes the backup schedule from the server. This action does not remove the backup schedule from the client, therefore the schedule can be assigned to the same database or a different one. Backup schedules for SQL Server databases are launched via the SQL Server agent only. There are a number of available default database backup schedules available for your use. The default schedules are listed along with your user-defined schedules in the Available Template Profile drop-down list.

     Daily Full Backups - Executes once per day at 2:00am

     Monthly Full Backups - Executes monthly on the first day at 2:00am

     Monthly Full Backups/Weekly Differential Backups/Daily Transaction Log Backups - Executes monthly on the first day at 2:00am, weekly on Saturday at 2:00am, and once per day at 2:00am.

     Weekly Full Backups - Executes weekly on Sunday at 2:00am

     Weekly Full Backups/Daily Differential Backups - Executes weekly on Sunday at 2:00am and once per day at 2:00am.

     Weekly Full Backups/Daily Transaction Log Backups - Executes weekly on Sunday at 2:00am and once per day at 2:00am.