A backup of virtual machine using Backup Exec 2010 generates an exception in the backup job log - "You must install the Agent for Microsoft SQL Server on the media server to configure the granular recovery of SQL data or truncate the SQL logs."

Article:TECH125052  |  Created: 2010-01-08  |  Updated: 2014-05-21  |  Article URL http://www.symantec.com/docs/TECH125052
Article Type
Technical Solution


Issue



During a Granular Recovery Technology (GRT) enabled backup of a virtual machine using Backup Exec 2010 Hyper-V Agent or Agent for VMware Virtual Infrastructure (AVVI), the above mentioned exception may be logged in the backup job log if the virtual machine is running Microsoft SQL.

 


Error



V-79-57344-38734 - Backup Exec has discovered Microsoft SQL Server on virtual machine '\ServerName\VM\Folder\VM_Name'. You must install the Agent for Microsoft SQL Server on the media server to configure the granular recovery of SQL data or truncate the SQL logs.  The Agent for Microsoft SQL Server is licensed on a per SQL server basis.
 


Cause



Backup Exec 2010 AVVI and Hyper-V Agent provide the GRT feature for both file system and SQL which allows to restore individual files/folders and individual SQL databases from a VMDK/VHD backup.  The above exception would be generated during backup of a virtual machine hosting Microsoft SQL databases if one or more of the following conditions were true:

  • Backup Exec Remote Agent is not installed on the guest machine
  • Backup Exec Remote Agent is installed but the Backup exec remote agent service is not running
  • A valid Backup Exec Agent for Microsoft SQL Server license is not installed on the Backup Exec 2010 media server

 


Solution



1. Install a valid Backup Exec Agent for Microsoft SQL license in Backup Exec console if the GRT feature for SQL databases is needed. Also install the Backup Exec Remote Agent on the virtual machine.

OR

2. Disable ALL application GRT for Hyper-V and VMware Backups. (See related documents section) if the GRT feature for SQL databases is not needed.
Note:  Simply disabling SQL GRT will continue to show the exceptions since all writers are queried by Microsoft VSS during the snapshot processing phase of the backup.  When VSS reports back to Backup Exec after the query there is a SQL writer, Backup Exec will add the "V-79-57344-38734" to the job log.  To ensure this exception is removed, disable ALL application GRT options for the backup job containing the SQL server showing the exception.  
 

Supplemental Materials

SourceUMI
ValueV-79-57344-38734
Description

You must install the Agent for Microsoft SQL Server on the media server to configure the granular recovery of SQL data or truncate the SQL logs.  The Agent for Microsoft SQL Server is licensed on a per SQL server basis.




Article URL http://www.symantec.com/docs/TECH125052


Terms of use for this information are found in Legal Notices