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 2010.

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

Database with Simple recovery model would only support  Full - Back up entire database or filegroup method .One cannot use the log backup methods to back up the master database as the Recovery Model of the database is set to Simple. 
 
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 2000 using Enterprise Manager and in SQL 2005 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 .
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)