Configuring Data Protection for SQL Server

Configuration requirements for Data Protection for SQL Server, Tivoli® Storage Manager, and other applications vary. The requirements depend on which Data Protection for SQL Server features you want to use. For example, if you plan on using VSS operations, the Tivoli Storage Manager backup-archive client (serving as the VSS requestor), must also be installed and configured.

1. Start the Management Console by clicking Start > All Programs > Tivoli Storage Manager > Data Protection for Microsoft SQL Server > DP for SQL Management Console.
2. From the start page, click Configuration. Alternatively, from the tree view, navigate to the Configuration node. Then, double-click Wizards.
3. In the results pane, double-click TSM Configuration to open the Tivoli Storage Manager Configuration Wizard.
4. Follow the instructions on the pages of the wizard and click Next to move to the next page.
   1. In the Data Protection Selection page, select SQL Server. Click Next.
   2. Review the results of the requirements check and ensure that you address any errors or warnings.

      Click Show Details to view a list of individual requirement results. If you are configuring an application for which you do not have the necessary license, the license requirement check fails. You must either go back to the Data Protection Selection page and clear the selected application to proceed with the configuration, or obtain the necessary license.

   3. In the TSM Node Names page, specify the Tivoli Storage Manager node names that exist on the same system to use for the applications that you want to protect.
      • In the VSS Requestor field, enter the node name that communicates with the VSS Service to access the SQL data. This node name is the Tivoli Storage Manager backup-archive client node name, also known as the DSM agent node name.
      • In the Data Protection for SQL field, enter the node name where the Data Protection application is installed. This is the node name that is used to store the Data Protection for SQL Server backups.
      • If you are configuring Data Protection for SQL Server for SQL Server 2012, enter a node name in the AlwaysOn Node field. This is the node name that is used to back up the availability databases in an AlwaysOn Availability Group. By default, the Windows Failover Cluster name is used.
      • If the Tivoli Storage Manager for Virtual Environments Recovery Agent license is available, enter the data center node name. The data center node is the virtual node that maps to a data center.

      Create a node name that can help you distinguish the type of backup that is run. For example, if your host name is MALTA, you can name the VSS requestor node name MALTA, and you can create a Data Protection node name that is called MALTA_SQL. For an SQL configuration, the AlwaysOn node name does not have to be related to the VSS Requestor or the Data Protection for SQL Server node name. For example, you can name it TSM_ALWAYSON.

   4. Enter information for the Tivoli Storage Manager server that you are connecting to and click Next to continue.
      • In the Tivoli Storage Manager Server Address field, enter the TCP/IP domain name or a numeric IP address for the Tivoli Storage Manager server that contains the backups. Obtain this information from your Tivoli Storage Manager server administrator.
      • In the Tivoli Storage Manager Server Port field, enter the port number for the Tivoli Storage Manager server that contains the backups. Obtain this information from yourTivoli Storage Manager administrator.
      • Specify whether to have the wizard to configure the Tivoli Storage Manager server for you by generating a configuration macro file.

        If you click No, the macro file is available at the final page of the wizard so that it can be provided to the Tivoli Storage Manager administrator as an example of one way to configure the Tivoli Storage Manager server to support application data protection.

        If you click Yes, the wizard starts the macro during the Configuration step in the wizard. Review the macro file and update it if needed.

        After you click Yes, enter the following information in the appropriate field:

        • The name of the Tivoli Storage Manager administrator account.
        • The password for the Tivoli Storage Manager administrator.
        • Click Test Communications if you want to test your connection with the Tivoli Storage Manager server. This button is not available until the VSS requestor is installed.
        • Click Review/Edit to review or update the Tivoli Storage Manager macro file. Alternatively, you can review the macro file and directly run the commands on the Tivoli Storage Manager server.
   5. Select the Default configuration setting. When you select the Default configuration setting, in addition to configuring the applications that you selected, the VSS Requestor is configured. The client and agent services are also registered and configured, and a schedule to support historical managed capacity is defined.
   6. Review the results of the configuration process. Click Show Details to view a list of individual configuration results.
5. Click Finish in the Completion page to complete the wizard.
6. Optional: For a VSS configuration, verify that the Run VSS diagnostics when this wizard exits option is selected. When this option is selected, after you complete the wizard, a diagnostic process tests the VSS snapshots on your system.
   Attention: If the configuration is for space-efficient target volumes for SVC or Storwize V7000, testing VSS snapshots deletes previous backups that are created for the volumes that are selected in the test wizard.