SQL Log Backup job fails if run after an AVVI or Hyper-V backup of the SQL Virtual machine.

Article:TECH137587  |  Created: 2010-08-11  |  Updated: 2013-03-07  |  Article URL http://www.symantec.com/docs/TECH137587
Article Type
Technical Solution

Product(s)

Issue



When doing an Agent for VMware Virtual Infrastructure (AVVI) or Agent for Hyper-V backup, the SQL logs are not truncated and a follow up SQL Log backup will then also fail.

 


Error



V-79-57344-38728: The SQL Database '<dbname>' on '<vmname>' is configured to maintain transaction logs, but transaction log backups are not being performed. Not backing up the transaction log results in the log growing in size until it fills all available disk space. You should either schedule regular logs backups or change the database to the simple recovery mode.

0xe0000363 V-79-57344-867: The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.

V-79-40960-37914 - Database <dbname> is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.

 


Environment



Media Server: Backup Exec 2010, R2 or R3 and BE 2012

Operating Systems:  Windows 2003, Windows 2008 (all variations)

SQL Versions: All Supported

ESX version: 4.x or Hyper-V

 


Cause



When an AVVI or Hyper-V backup job runs, a Full SQL backup is performed which does not truncate the logs. This job also records the last backup requestor for the database in SQL as NULL or NONE instead of the Backup Exec SQL Agent, because it was the VM snapshot process that made the last backup request. This then causes a later SQL Log job to also fail, as long as a Full SQL job has not been run since the AVVI or Hyper-V backup job.

 For more information on how to identify the requester please see: www.symantec.com/docs/TECH58674

 


Solution



To backup a SQL Server located inside a Virtual Machine (VM), that is not configured for Simple Recovery Mode and to truncate the logs, run standard SQL Agent Full and Log backup through the remote agent installed inside the VM.

If AVVI or Hyper-V backup jobs are still scheduled, these must be scheduled so that they do not interrupt the sequences of SQL Agent Full and Log backup jobs.

 


Supplemental Materials

SourceUMI
ValueV-79-57344-38728
Description

The SQL Database '<dbname>' on '<vmname>' is configured to maintain transaction logs, but transaction log backups are not being performed. Not backing up the transaction log results in the log growing in size until it fills all available disk space. You should either schedule regular logs backups or change the database to the simple recovery mode.

 


SourceUMI
ValueV-79-57344-867
Description

The Backup Exec SQL Agent was not used to create the last full, differential, or log backup of this database. You must use the SQL Agent to run a full backup before you can run a differential backup or transaction log backup.

 


SourceETrack
Value2112829
Description

A SQL Log Job is unable to run if it follows an AVVI Job against the SQL VM

 


SourceUMI
ValueV-79-40960-37914
Description

V-79-40960-37914 - Database <dbname> is configured to maintain transaction logs. Transaction log backups are not being performed. This will result in the log growing to fill all available disk space. Regular log backups should be scheduled or the database should be changed to the simple recovery mode.




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


Terms of use for this information are found in Legal Notices