SQL database backup with the backup type Log - Backup transaction log , fails with the error: "0xe00084a8- A log backup was attempted on a database that is not currently configured to support log backups."

Problem

SQL database backup with the backup type Log - Backup transaction log , fails with the error: "0xe00084a8- A log backup was attempted on a database that is not currently configured to support log backups."

Error Message

Error: 0xe00084a7 - The SQL Server master database does not support log backups. Only full backups can be performed on the master database.

Error: 0xe00084a8- A log backup was attempted on a database that is not currently configured to support log backups.

NOTE: These messages will appear as exceptions, not errors, in Backup Exec.

The Backup job fails with below error if log backup of Master database is attempted. (Figure 1)

Figure 1

 


The Backup job also fails with below error if log backup of database is attempted whose recovery model is set to Simple. (Figure 2)

Figure 2

  

 

Cause

A backup job fails because of following reasons

1. If log backup of Master database is attempted

2. If log backup of database is attempted whose recovery model is set to Simple.

Solution

1.  Run a Full backup of databases whose Recovery Model is simple.

2. In scenarios where its essential to perform Log backup , manually exclude the Simple recovery model databases from the selection list .

Refer to Figure 3 and Figure 4 , to check recovery model in SQL using Management Studio .

Figure 3

 

Figure 4

 


1. Run a Full backup of databases whose Recovery Model is simple.

2. In scenarios where its essential to perform Log backup , manually exclude the Simple recovery model databases from the selection list .