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
- Log on to the virtual machine that hosts the Microsoft SQL Server database (vm_sql10).
- 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.
- 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.
- After Data Protection for Microsoft SQL Server is
configured, verify that the Configuring Recovery Agent rule
status indicates Passed.
- Log on to a data mover instance and complete the following
steps. Do not repeat these steps for all data mover instances.
- 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).
- If the current data mover options file (dsm.opt)
contains an ASNODE entry, create a temporary
options file. Complete the following steps:
- Copy the contents of the dsm.opt file to
the dsm.setaccess.opt file.
- Edit the dsm.setaccess.opt file. Delete any
line that contains an ASNODE entry.
- Edit the dsm.setaccess.opt file to set the NODENAME option
to the following entry:
NODENAME DC_NODE
For
example: DC_NODE = datacenter10
- 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.