SQL Backup completed with exception - Backup Exec

SQL Versions – Sql 2005 and Above

Backup Technology – Symantec Backup Exec

Scenario 1:

SQL Backup will complete successfully.

However, with below exceptions,

V-79-57344-33959 - The master database only supports full backups. Differential and log backups cannot be performed on the master database.

Scenario 2:

SQL Backup will complete successfully.

However, with below exceptions –

V-79-57344-33960 - A log backup was attempted on database msdb that is not configured to support log backups. To change the configuration, use the SQL administration tools to set the recovery mode to Full. A new full backup should be performed if this setting is changed before a log backup is run.

First Understand, Backup Schedules for SQL. Most Scenarios will contain two SQL Backups (FULL + Log files Backups).

Reason why we see above error exception:

SQL Databases maintains their own recovery model like Simple, FULL & Bulk Logged through which logs or transaction logs will be maintained. It is not possible to take log files backup for any database if database recovery model is simple.

Reference Link:

http://msdn.microsoft.com/en-IN/library/ms189275.aspx

Troubleshooting Steps:

Logon to Backup Exec Server, Open Sql Backup Job and check backup selection list for Log backups.

If it is log backup job, then you will see options under SQL backup properties -> settings -> Microsoft SQL

è Log- backup transaction log.

Reference Screenshot:

Check under backup selection list, what all SQL Databases are selected,

Make sure that SQL System Databases Master & MSBD are not selected for Sql Log Backups as per their recovery models they will not support transaction log backups

Resolution:

Make Customer Understand that why SQL Backups completing with exceptions.

In order to overcome the exceptions, they need to uncheck SQL System Databases (Master, MSDB) from Log backup job.