https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/

Step 4: Scheduling

Estimated reading: 4 minutes 0 views

The schedule option defines the frequency of your MSSQL Backup job.

Full Backup Schedule

You can configure the full backup schedules by choosing between Run One Time/Run Daily/Run Weekly/Run Monthly options.

Note: The recommended interval is to schedule full backups every 3 or 6 months.

Select Run One Time option if you want to run your backup only for once.https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/
If you want to run your backup every day, select the Run Daily option and configure the period in which your backup has to occur.
If you want to run your backup every week on a specific day and time, choose the Run Weekly option. Select the time frame and day in which you want to run the backup.
If you want to run your backup using the monthly option then choose the months when ‘Full Backup’ should run.

Differential Backup Schedule

While performing the differential backup schedule, the BDRSuite Backup Server will only dump the changes of the database since the previous full backup.

Enable the differential backup schedule by toggling the slider to the right. Once enabled you will have to specify the frequency of the differential backup schedule. You can specify it to run on a every few minutes, hourly, daily, weekly or monthly basis.

Note: The recommended frequency is to schedule differential backups either on a weekly or monthly basis.

Transactional Log Backup

You can backup all the transactional logs since the previous backup schedule.

Enable the transactional log backup by toggling the slider to the right. Once enabled you will have to specify the frequency of the transactional log backup. You can specify it to run on a every few minutes, hourly, daily, weekly or monthly basis.

Note: The suggested frequency is to schedule transactional log backups every few hours or on a daily basis.

Advanced Schedule Settings

The Advanced Schedule Settings allow you to specify the Backup Window time and Backup Validity for your backup job.

Backup Window

If you don’t want the backup run at a specific time interval, then you can specify it in the backup time window. The backup window prevents the backup job from running during peak production hours and ensures there is no unwanted overhead in the production environment. Select one of the available options to set up the backup window for your backup job

Use Global Setting s : Selecting the‘ Use Global Settings’ option will apply the Backup Window setting of your backup server to this backup job. You can set up the global backup window settings for your entire backup server at Backup > Configure Backup Settings > Backup Window.

In case, if you are selecting the ‘Use Global Settings’, but if global backup window settings are disabled for your backup server, then the job will run as per its schedule
If you are modifying the Global Backup Windows settings later, it will affect all the backup jobs that are selected with ‘Use Global Settings’

Use Custom Settings : On selecting ‘Use Custom settings’, you have to specify the start time and end time for the window. The backup job will not during the selected time interval. You can also specify the applicable days for the backup window settings such as Mon-Fri or All days. Selecting the ‘Use Custom settings’ will override the global backup window settings.

No Preferences : Selecting ‘No Preferences’ will override the global backup window settings and the backup job will run as per the schedule.

Backup Validity

Set the validity for your backup job by specifying the start date and the expiration date. The Backup job will start to run only after the start date.

If you want a backup job to start to run later, for example, 5 days later from the day you have created the backup job, then you can specify the start date of the backup job accordingly. The expiry date is optional for a backup job, if the expiry date is set the incremental backup or additional full backup does not proceed after that.