How do I ignore simple recovery mode databases?
Hello,
I have many sql transaction log backups partially completing. checking the detailed status I found:
"Operation inhibited by NetBackup for Microsoft SQL Server: Only a full or incremental database backup can be performed on database <StageCDR> because it uses the simple recovery model or has 'truncate log on checkpoint' set."
Obviously understanding that the database attempted to backup is in simple recovery model and therefor cannot be backed up.
our backup scripts look like:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "<SERVER NAME>"
NBSERVER "<MASTER-SERVER>"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE
is there a way to exclude all databases using simple recovery model?
Hi, To exclude any DB from SQL DB backup by NetBackup for SQL agent , add following line in your .bch file.
EXCLUDE ''Database_name"
for example you want to exclude datababe name master then script should be like :
OPERATION BACKUP
DATABASE $ALL
EXCLUDE "master"SQLHOST "<SERVER NAME>"
NBSERVER "<MASTER-SERVER>"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE