Configuring multistriped backups

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. This configuration is useful if the tape device is a bottleneck.

Generally Symantec does not recommend that you enable multiplexing for a schedule that is used for backing up multiple stripes.

Backup images can be written to more tapes than available drives. If this situation, in the batch file for the restore operation, indicate the number of drives that are available.

To configure a multistriped backup

  1. In your "Application Backup" policy, set Media multiplexing to one in the schedule you want to use for striped backups or restores.

    Then multiplexing is disabled for this schedule. All streams are made simultaneously available so restore operations are successful.

  2. Ensure that the storage unit has as many drives as you want to have stripes.

  3. Configure schedules for backups and restores so that enough drives are available at the time you want to perform striped backups or restores.

  4. In the Backup Microsoft SQL Server Objects dialog box, select a Stripes setting greater than 1.

More Information

Restoring multistreamed backups

Backup Microsoft SQL Server Objects dialog box

Restoring multistreamed backups