Specifying Data Protection for SQL Server node name parameters

Edit online

You must register the system where Data Protection for SQL Server is installed to the IBM Storage® Protect server with a node name.

About this task

When you configure Data Protection for SQL Server, the IBM Storage Protect configuration wizard manages the creation of the IBM Storage Protect nodes and node attributes. You can customize the configuration template script to add additional node attributes, for example, backup compression. Alternatively, to customize IBM Storage Protect nodes, you can use the Administrative client options with the DSMADMC command.

The node name owns and manages all Data Protection for SQL Server data that is backed up to the IBM Storage Protect server.

If you run Data Protection for SQL Server on a Microsoft™ Failover Clustering or Veritas Cluster Server, the node name cannot be the name of the local system. The node name must match the SQL virtual server name.

Procedure

  1. Specify the node name with the nodename option in the dsm.opt options file.
    By default, the dsm.opt options file is in the Data Protection for SQL Server installation directory.
  2. To run VSS operations, register node names for more systems if required.
  3. Configure the following IBM Storage Protect parameters when you register your Data Protection for SQL Server node name to the IBM Storage Protect server:
    • BACKDELete Specify that the Data Protection for SQL Server node can delete its own backup files from the IBM Storage Protect server. You must specify the yes value for this parameter.
    • MAXNUMMP Specify the maximum number of mount points that a client node is allowed to use on the IBM Storage Protect server during a backup operation. If you use SQL data-striping with data that is sent directly to a tape pool, set this parameter to a number that is greater than the default value of 1. For example, set this value to be at least the maximum number of stripes to be used for backup or restore operations when removable media such as tapes are used, or if migration occurs during the backup or restore operation. If other backups or restores operations occur at the same time, the value of this parameter must be large enough to allow for all of the required mount points. If the storage pool for the backup operation has Active Data or Backup Stgpools that are written to simultaneously, the MAXNUMMP parameter must also include these mount points.
    • TXNGroupmax Specify the number of files that are transferred as a group between Data Protection for SQL Server and the IBM Storage Protect server, between transaction commit points. This parameter must have a value of 12 or greater.
    • COMPRESSIon (Legacy only) Specify whether the Data Protection for SQL Server node compresses data before it sends the data to the IBM Storage Protect server during a backup operation. Specify COMPression=Client in the backup-archive client options file (dsm.opt) in theData Protection for SQL Server directory.