SQL database issue V-79-57344-38728 via VMAgent
Created: 17 Aug 2012
I have no issues with SQL database backup if i run it using the Windows Agent, but all GRT backup using VM Agent drives me to the same error
V-79-57344-38728 - The SQL database 'DB' on virtual machine '\(DC)...(DC)\vm\Discovered virtual machine\SQL' 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 log backups or change the database to the simple recovery mode.
For restore I do not any database under my instance as well
How can I fix it?
Comments
Refer
Refer to http://www.symantec.com/docs/TECH128944
Amol
I seen that before, bat do
I seen that before, bat do not understand that I have to do
Full recovery model logs are
Full recovery model logs are not purged during full backup. So you need to setup a seperate Full - Incremental Log Backup for these SQL databases so that the Log backups can truncate the logs. One Full/Log backup cycle once every 10 days shouldbe good enough to prevent this error for coming up.
This will help you to fix
https://www-secure.symantec.com/connect/forums/backup-exec-2012-sql-transaction-log-backups
@lampar - What you need to do
@lampar - What you need to do is in addtion to your VM backup. Add another job which will backup the SQL databases and within this job, add a incremental backup to backup the log. See
https://www-secure.symantec.com/connect/forums/backup-exec-2012-sql-transaction-log-backups#comment-6905511
The log backup will clear up the transaction log and the error message will not appear. You got to make sure that there is no VM backup between the database backup and the log backup. I would suggest that you do the two jobs back-to-back.
Would you like to reply?
Login or Register to post your comment.