Using NetBackup for SQL Server with Snapshot Client How SQL Server operations use Snapshot Client
The following requirements must be met for a grouped backup to be performed. If any of these requirements are not met, a standard backup will be performed.
All backup operations must be full backups. Differential backups are not supported.
The master database can not be included in a grouped backup.
The same policy must be specified for each backup operation in the group.
The same NetBackup server must be specified for each backup operation in the group.
The simplest way to use grouped backup is to select multiple databases using the Backup Microsoft SQL Server Objects dialog box. If the above conditions apply, then the selected databases will be backed up as a group.
Viewing the progress of a grouped backup
You can determine that a grouped backup is underway from the progress report.
Refer to the figure “Progress report for a grouped backup operation.” The keyword GROUPSIZE appears at the beginning of the batch file. This indicates that NetBackup will attempt to use grouping to back up the selected SQL Server databases. If the appropriate conditions apply, for example, all operations are full database backups, then all of the databases will be snapped and backed up as a group. When this happens, the progress log will display the backup image name as well as the storage image for each database in the group.