Video Screencast Help

A database backup completes with exception: V-79-40960-37914 on Backup EXEC 2012

Created: 25 Mar 2013 | 3 comments

A database backup completes with exception: V-79-40960-37914 - Database DATABASENAME 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.

There are three databases users access, these databases Recovery Model are set to Full, and on the Backup EXEC 2012, I only select these databases for backup to tape, other system database (master, temp, msdb, model) is not selected.

We only configure one FULL backup everyday for the SQL Server, not configure the Incremental backup as attachment.

However, after a few backup, the error V-79-40960-37914 occur, and as based I'm understand, the transaction log for the SQL database will not be backup.

So, please advice how can I backup the transaction log for three databases.

Thanks

Operating Systems:

Comments 3 CommentsJump to latest comment

Vivek Jain's picture

Add an incremental stage to the backup definition. Choose MS SQL on the left side & on the right side, set the incremental type to log.

pkh's picture

1) Edit your job properties

BE 2012 - edit job properties.png

2) Add an incremental job

BE 2012 - add job.png

3) Change the incremental job to backup logs

BE 2012 - SQL log backup.png