Please enter search query.
Search <product_name> all support & community content...
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.