Configure multistriped backups of SQL Server
SQL Server supports backups of databases through multiple data streams, which are called stripes. NetBackup stores each stripe as a separate image. The purpose of this feature is to speed up the rate of data transmission with the use of multiple tape devices.
Backup images can be written to more tapes than available drives. When you restore this type of backup image, in the restore batch file indicate the number of drives that are available.
Caution:
Do not enable multiplexing for a schedule that is also configured to backup with multiple stripes. Restores fail when multiplexing is enabled for a schedule that uses more than one stripe.
Configure the following to create a multistriped backup:
In the backup policy, select the number of you want to use.
For a SQL Server Intelligent policy, configure this setting on the tab. For batch file-based SQL Server policies, configure the setting when you create the backup batch file.
In the schedules for your policy, set to to disable multiplexing.
For batch file-based policies, disable multiplexing in the "Application Backup" schedule. When you disable multiplexing, during a restore all streams are made available simultaneously so the restore operations are successful.
Ensure that the storage unit has as many drives as you want to have stripes.
Configure backup schedules so that enough drives are available at the time you want to perform striped backups.
More Information