You can create a customized database backup schedule or modify an existing one. The SQL Server agent manages the steps necessary to successfully create or modify a database backup schedule.
Note: Modifying database backup profiles can temporarily affect the ability to perform a database recovery.
To create or modify a schedule, select Backup > Create Backup Schedule from the SQL Server agent’s main menu.
If a new profile is being created, select Create a New Template Profile and provide a name for the profile. If an existing profile is being modified, select Modify an Existing Template Profile and select a name from the list of currently existing user-defined backup profiles.
One of the features of the SQL Server agent is to allow a means to easily develop backup profiles based on specific database recovery requirements. The next step in creating a backup profile gathers the requirements that will be used to formulate a customized backup strategy. Click Next to continue.