03-25-2013 01:50 AM
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
03-25-2013 02:27 AM
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.
03-25-2013 02:29 AM
...have you checked the TN below:
http://www.symantec.com/business/support/index?page=content&id=TECH126063
Thanks!
03-25-2013 10:05 PM
1) Edit your job properties
2) Add an incremental job
3) Change the incremental job to backup logs