cancel
Showing results for 
Search instead for 
Did you mean: 

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

Alex_de_Souza
Level 4

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

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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. 

View solution in original post

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

 

Alex_de_Souza
Level 4

Sorry, I did not understand.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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. 

Alex_de_Souza
Level 4

Thanks Marianne