Introduction

Here you can select the certain databases you would like to apply your configs to as well as view the setup configs.

To get started select the backup and maintenance Icon and choose database configuration:

Make use of the database groups to populate the below table of databases with the instances in the database group.

Use the header checkbox to Select All visible databases, or tick individual rows, before you run a bulk action.

Manual Operations

After selecting one or more databases, use Manual Operations to run a job immediately (outside the configured schedule window):

• Execute Manual Backup
• Execute Manual Maintenance
• Execute Manual Index Rebuild

SQLPro asks you to confirm before the job starts, for example: Are you sure you want to execute manual backup for 3 selected database(s)? After you accept, a notification confirms that the operation was initiated.

Bulk Update

Here you first select all the databases you wish to configure on the right and click the 'Bulk Update' button on the top right of the table.

This will then bring up the following menu:

Here if you so choose you can change the following settings if you do not want the global default settings applied:

• Full Backup Schedule and path
• Log Backup Schedule and path
• Maintenance Backup Schedule
• Rebuild Indexes Schedule

You can choose to rebuild indexes which will reduce fragmentation in your indexes. Get the best use out of this if you have a large database with tables with millions of rows.

If you wish to have more control over the bulk updates you can export as a CSV and adjust the settings in Excel and then simply import the CSV when you are done.

Configs can also be set for individual databases.

Edit the configuration for a single database in the same way as you'd do a group of databases.