Configuring multiplexed backups of SQL Server
Multiplexing lets you interleave multiple backups to the same tape. This feature is useful if you have many simultaneous backups that use the same tape drive.
However, multiplexing can interfere with SQL Server recovery due to how SQL Server requests streams during a restore. If you enabled multiplexing for multistreamed backups, see the information on how to perform restores. To restore a multiplexed backup, you must configure the restore for one stripe.
Configure the following to create a multiplexed backup:
In the backup policy, select the number of you want to use.
For SQL Server Intelligent policy, configure this setting on the tab. For batch file-based policies, configure the setting when you create the backup batch file.
In the schedules for your policy, set to the number of backup stripes that you want to use.
For batch file-based policies, enable multiplexing in the "Application Backup" schedule.
In the storage units that are associated with this schedule, select and set to the number of stripes that you want to use.
More Information