PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Enable multi-stream backups for SQL protection policy

To enable multi-stream SQL 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 preceding topic describes how to set the stripe level at the individual database level for a self-service stand-alone SQL Server backup performed through PowerProtect Data Manager.

The following procedure enables the setting of separate stripe levels for the backup types that are supported for SQL. 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.

CAUTION After you update from version 19.5, centralized backups ignore any parallelism and backup stripe settings that were previously configured on the Extended Properties page in SQL Server Management Studio (SSMS). For centralized backups with version 19.6 or later, you must configure the parallelism settings through the PowerProtect Data Manager UI.

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

Select Infrastructure > Assets > SQL.
Select the required SQL asset.
Select More Actions > Set Stream Count.
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.
Click Save.