Edit SQL Server Backup Schedule

• Overview
• How to get here in the StoreGrid Web Console?
• Edit SQL Server Backup Schedule
• Troubleshooting Tips
• Limitations

Overview

This section will give you information about how to edit a configured Basic/Advanced SQL Server backup schedule in StoreGrid.

How to get here in the StoreGrid Web Console?
 In the top menu, select: "Backup->List Backup Schedules". From the list of backup schedules, click on the edit icon in the Action column of the MS SQL Server backup schedule that you want to edit.

Edit SQL Server Backup Schedule

This page is used to edit a configured MS SQL Server backup schedule. Note that only some of the configuration options are editable.

Edit the SQL Server backup schedule details as required. The following options are editable:

• Select Database(s) - This option allows you to add/remove SQL database[s] from an existing backup schedule. The database(s) can be selected based on recovery model.
• CPU Utilization settings.
• Full Backup Scheduling settings.
• Differential Backup Scheduling settings.
• Transaction Log Backup Scheduling settings.
• Max. No. of Full backups to be retained in the server.
• Max. No. of Differential backups to be retained in the server.
• Read and verify the integrity of the backup on completion.
• Run this backup every 5/10/15/20/25/30 minutes in case of non completion because of a problem(Network error etc.). The number of times the backup will be rescheduled(due to an error) can be configured to be in between 1-5 or unlimited, with the default setting as 5.
• Temporary location for backup dumps.

The following options are additional configurable options:

• Run additional full backup after saving this configuration :
  When this option is selected StoreGrid will take an additional full backup for the SQL Server database(s) configured in this schedule after saving this configuration.

• Suspend Backup
  This option shows the status of this backup schedule, whether it is suspended or not. And the same option can be used to suspend the backup schedule.

Please note that the following options are not editable:

1. Compression type.
2. Encryption (and password).
3. Backup Server(s).

Troubleshooting Tips

Limitations

1. Some of the backup schedule parameters cannot be edited. Editing settings like compression and encryption will make the new backup data and the old backup data (already backed up) incompatible.