Dell PowerProtect Data Manager Appliance 5.12.0.1 Microsoft SQL Server User Guide

Configure the database backup stripe level

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 T-SQL statements 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';