Online Documentation for SQL Backup for SQL Server
Schedule backup database task daily
If you want a backup database task to be executed daily you need to create a policy with a Backup Database step and a schedule with appropriate parameters.
In order to do this perform the following operations:
-
choose the database in the server explorer and select the
Maintenance Policies |
Create New Policy item of its context menu;
-
on the second step of policy wizard select the Steps section and click the
Add button;
-
in the Select Step dialog select the
Backup Database item;
- in the Backup Database step wizard opened configure backup settings; after all wizard steps completion the Backup Database step appears in the Steps list;
-
select the Schedules section and click the
Add button;
- in the opened Schedule editor set the following parameters:
-
Schedule type -
Recurring from date,
- Occurs - Daily,
- Recurs every - 1 day,
-
Daily frequency -
Occurs once at,
- Occurs once at - launch time for backup database task execution;
then press the OK button
- complete all steps of the policy wizard.