Forum Discussion

gkman's avatar
gkman
Level 5
9 years ago

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...
7.6
Backup and Recovery
NetBackup
Windows Server (2003-2008)
  • NBU35's avatar
    NBU35
    9 years ago

    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

Michal_Mikulik1's avatar
Michal_Mikulik1
Moderator
9 years ago

Hello,

with backup scripts, no.

However if you are on 7.7 (both Master Server and Client), you can switch to so-called intelligent MS SQL policies. They don't use local backup scripts and during transaction log backups, they are able to skip databases with Simple recovery model automatically.

Regards

Michal