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

Article:TECH45850  |  Created: 2006-01-06  |  Updated: 2013-02-26  |  Article URL http://www.symantec.com/docs/TECH45850
Article Type
Technical Solution


Issue



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



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 .

Supplemental Materials

SourceUMI
ValueV-79-57344-33959
Description

Only full backups can be performed on the master database.


SourceError Code
Value0xe00084a8
Description

A log backup was attempted on a database that is not currently configured to support log backups


SourceUMI
ValueV-79-57344-33960
Description

A log backup was attempted on a databse that is not currently configured to support log backups.


SourceError Code
Value0xe00084a7
Description

The SQL Server master database does not support log backups.



Legacy ID



281308


Article URL http://www.symantec.com/docs/TECH45850


Terms of use for this information are found in Legal Notices