PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Enable multi-stream backups for Microsoft SQL Server protection policy

To enable multi-stream Microsoft SQL Server backups for a centralized protection policy, you can set the parallelism value in the PowerProtect Data Manager UI. The parallelism value controls the number of parallel streams that the Microsoft application agent uses to write the backup data to DD.

The following procedure enables the setting of separate stripe levels for the backup types that are supported for Microsoft SQL Server. If you do not change the settings, the default settings are used for a centralized backup, with a default stripe value of 4 for full and differential backups and a default stripe value of 1 for log backups.

In the PowerProtect Data Manager UI, perform the following steps to set the parallelism for multi-stream backups:

1. Select Infrastructure > Assets > SQL.
2. Select the required Microsoft SQL Server asset.
3. Select More Actions > Set Stream Count.

4. Set the stream count for each backup type as a value between 1 and 32 in the Full, Differential, and Log fields. The default stream count values are 4 for full and differential backups and 1 for log backups.

   NOTE:A stream count value of 1 is recommended for log backups.
5. Click Save.