PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Configure the database backup stripe level

Starting with version 19.5, you can modify the stripe level of a backup at the individual database level by using the following procedures. Starting with version 19.6, you can set the stripe level through the following procedures only for self-service stand-alone SQL Server backups, not for centralized backups performed through PowerProtect Data Manager.

The backup stripe level configuration includes the following features:

• The backup stripe level setting for individual databases has a higher priority than the stripe level setting through the backup command with the -S option.
• For any database, the minimum supported stripe level is 1 and the maximum supported stripe level is 32.
• In an FCI or AAG cluster, setting the backup stripe level of a database at any node reflects across all the nodes in the cluster.

To set the backup stripe level for any database, use either of the following procedures:

• Perform the following steps in the SQL Server Management Studio (SSMS):

  1. Right-click the database name, and select Properties.
  2. In the properties window, select Extended Properties from the left side pane.

  3. Add the required property name and the backup stripe level value:

     • For a full backup, add the property name ppdmFullStripes and a value between 1 and 32.
     • For a differential backup, add the property name ppdmDiffStripes and a value between 1 and 32.
     • For a log backup, add the property name ppdmLogStripes and a value between 1 and 32.

  

• Run the following SQL commands to set the backup stripe level for any database:

  USE <database_name>;
  GO
  EXEC sp_addextendedproperty
  @name = N'ppdmDiffStripes',
  @value = '4';
  EXEC sp_addextendedproperty
  @name = N'ppdmFullStripes',
  @value = '8';
  EXEC sp_addextendedproperty
  @name = N'ppdmLogStripes',
  @value = '2';