Step 4: Scheduling
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.
