Configuring Data Protection for Microsoft SQL Server

After you configure Data Protection for VMware and verify that you created a virtual machine backup suitable for recovery of a single Microsoft SQL Server database, configure Data Protection for Microsoft SQL Server in the guest virtual machine.

Procedure

  1. Log on to the virtual machine that hosts the Microsoft SQL Server database (vm_sql10).
  2. Verify that the following packages are installed:
    • Data Protection for VMware recovery agent and license (from the Data Protection for VMware product package)
    • Tivoli® Storage Manager backup-archive client
    • Data Protection for Microsoft SQL Server

    You can install the Data Protection for VMware recovery agent, license, and Tivoli Storage Manager backup-archive client together by using the Data Protection for VMware installation program. To install the packages together, select the following advanced installation option: Install Data Protection for VMware instant restore features only. Data Protection for Microsoft SQL Server is installed separately.

  3. Configure Data Protection for Microsoft SQL Server by using the Tivoli Storage Manager configuration wizard. When you open the Tivoli Storage Manager Node Names page of the wizard, enter the VMware datacenter node name, SQL Server node name, and VSS requestor node name. If the datacenter node name field is disabled, the Data Protection for VMware recovery agent is not installed correctly.
  4. After Data Protection for Microsoft SQL Server is configured, verify that the Configuring Recovery Agent rule status indicates Passed.
  5. Log on to a data mover instance and complete the following steps. Do not repeat these steps for all data mover instances.
    1. For the Tivoli Storage Manager backup-archive client that is configured as the VSS requestor node, for example, sql10, authorize the virtual machine backups, for example, assign file space for vm_sql10 by using the client set access command at the command line. Enter the following command:
      dsmc set access backup -type=VM vm_name vss_requestor_node
       -optfile=dsm.setaccess.opt
      You must complete this step because the VSS requestor node accesses the virtual machine backups on behalf of Data Protection for Microsoft SQL Server.

      Run this command directly from the datacenter node (datacenter10).

    2. If the current data mover options file (dsm.opt) contains an ASNODE entry, create a temporary options file. Complete the following steps:
      1. Copy the contents of the dsm.opt file to the dsm.setaccess.opt file.
      2. Edit the dsm.setaccess.opt file. Delete any line that contains an ASNODE entry.
      3. Edit the dsm.setaccess.opt file to set the NODENAME option to the following entry:
        NODENAME DC_NODE
        For example:
        DC_NODE = datacenter10
      4. Enter the following command:
        dsmc set access backup -type=VM vm_name vss_requestor_node
         -optfile=dsm.setaccess.opt

Example

dsmc set access backup –type=VM vm_sql01 sql01 –optfile=dsm.setaccess.opt

ANS1148I "Set Access" command successfully completed.

dsmc query access
Node name: datacenter10
Type		Node		User		Path
------	------	------	------
Backup 	sql10 	* 		\VMFULL-vm_sql10\*\*


ANS1148I "Query Access" command completed successfully

If the password for the datacenter node name is unknown, the Tivoli Storage Manager server administrator must reset the password to issue the set access command.