Forum Discussion

Alex_de_Souza's avatar
Alex_de_Souza
Level 4
10 years ago

ERR - bphdb exit status = 1: the requested operation was partially successful

Hello, I need some assistance, some are showing up transactionlog status (1) everyday at the same time as print below:

Capturar.JPG

Master node cluster: Linux Red Hat 5.5  -  NBU: 7.6.0.2

Media Server:  Linux Red Hat 5.5  -  NBU: 7.6.0.2

Client: SQL 2012 Enterprise  - S.O: Win Server 2012 R2 Standard NBU: 7.6.0.2

Job Details: see attachment

 

dbclient:  see attachment

 

Transactionlog script:

GROUPSIZE 10
OPERATION BACKUP
DATABASE "Cluster"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "master"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "MetricStorage"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "model"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "msdb"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "RequestStorage"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "SnmpPoller"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "TesteDB"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "TraceAnalyser"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

OPERATION BACKUP
DATABASE "Traces"
SQLHOST "SDB-SQL-3"
NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
STRIPES 2
MAXTRANSFERSIZE 6
BLOCKSIZE 2
OBJECTTYPE TRXLOG
NUMBUFS 2
ENDOPER TRUE

7.6
Backup and Recovery
Configuring
Error messages
Linux
NetBackup
  • Marianne's avatar
    Marianne
    10 years ago

    You cannot perform Transaction log backup of SQL master database.

    Remove this section from the backup script:

    OPERATION BACKUP
    DATABASE "master"
    SQLHOST "SDB-SQL-3"
    NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
    STRIPES 2
    MAXTRANSFERSIZE 6
    BLOCKSIZE 2
    OBJECTTYPE TRXLOG
    NUMBUFS 2
    ENDOPER TRUE

    Same for mdsb:

     Operation inhibited by NetBackup for Microsoft SQL Server: Only a full or incremental database backup can be performed on database <msdb> because it uses the simple recovery model or has 'truncate log on checkpoint' set.

     

    Remove msdb from the script as well. 

4 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    Here is the problem:  

    Operation inhibited by NetBackup for Microsoft SQL Server: Only a full backup can be performed on the master database.

     

    You need to remove master database from transaction log backups.

     

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    You cannot perform Transaction log backup of SQL master database.

    Remove this section from the backup script:

    OPERATION BACKUP
    DATABASE "master"
    SQLHOST "SDB-SQL-3"
    NBSERVER "NETBACKUP-MASTER.ADM.INFRA"
    STRIPES 2
    MAXTRANSFERSIZE 6
    BLOCKSIZE 2
    OBJECTTYPE TRXLOG
    NUMBUFS 2
    ENDOPER TRUE

    Same for mdsb:

     Operation inhibited by NetBackup for Microsoft SQL Server: Only a full or incremental database backup can be performed on database <msdb> because it uses the simple recovery model or has 'truncate log on checkpoint' set.

     

    Remove msdb from the script as well.