Resolving database access problems

If you backed up a guest virtual machine that hosts a Microsoft SQL Server application, you might not be able to access the databases with Data Protection for SQL.

To resolve the database access problems, complete the following steps:

1. Verify that application protection was used when you created the virtual machine backup:
   1. From the Command Prompt window, issue the following backup-archive client command to display the list of successful virtual machine backups on the server:

      dsmc -node=datacenter_node query vm vm_name -detail

      Where datacenter_node is the name of the virtual node that holds the data in the data center, and vm_name is the name of the virtual machine that you backed up.
   2. Verify that the output of this command contains the following output fields:

      application protection type: ‘TSM VSS’
      application(s) protected:    ‘MS SQL 2008 – database-level recovery’

      If the command output does not contain these output fields, or the second field does not include the database-level recovery text, complete the following steps:

      1. Ensure that the V7.1 or higher backup-archive client is installed on the data mover node and the client options file contains the include.vmtsmvss vm_name option.
      2. Back up the guest virtual machine again.
2. Verify that the computer name of the guest virtual machine did not change after the backup of the virtual machine was created.
3. Verify that the in-guest DSMAGENT node has access to the data center node virtual machine backups.
   1. Issue the following command to verify that the client node has access to backup versions of the virtual machine on the server:

      dsmc –node=datacenter_node query access

      Where datacenter_node is the name of the virtual node that holds the data in the data center.
   2. Verify that the command output contains the following fields:

      Type     Node            User   Path
      ----     ------------------------------------------
      Backup   dsmagent_node  *     \VMFULL-vm_name\*\*
      

      If the output does not contain this information, rerun the set access command on the data mover node to give the DSMAGENT node access to the guest virtual machine backups. For example, issue the following command:

      dsmc set access backup –type=vm dsmagent_node vm_name

      Where dsmagent_node is the backup-archive client node name in the virtual machine guest, and vm_name is the name of the virtual machine that you backed up.