Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

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.

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, as described in the next topic.

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.
    Figure 1. Extended Properties page with backup stripe levels
    Extended Properties page with backup stripe levels
  • 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';

  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\