NetBackup for SQL Server transaction log backup fails with error "Only a full or incremental database backup can be performed on database because it uses the simple recovery model"

Article: 100030238
Last Published: 2015-01-19
Ratings: 1 0
Product(s): NetBackup & Alta Data Protection

Problem

NetBackup for SQL Server transaction log backup fails or is partially successful

 

Error Message

<16> Dbbackrec::PerformNBOperation: USER - Operation inhibited by NetBackup for Microsoft SQL Server: Only a full or incremental database backup can be performed on database because it uses the simple recovery model.

Cause

This occurs when attempting a transaction log backup (OBJECTTYPE TRXLOG) for a database whose recovery model is set to "simple".

 

Solution

Exclude the affected database from the transaction log backup, or change the database's recovery model to "full" in SQL Server.

To exclude a specific database from the backup batch file, add a line to the batch file using the EXCLUDE keyword and the database name in quotes.  For example:

       EXCLUDE "master"

Consult the SQL Server documentation for more information about database recovery models, and whether changing the recovery model is appropriate for the site.

 

Was this content helpful?