11-07-2014 05:36 AM
Hello, I need some assistance, some are showing up transactionlog status (1) everyday at the same time as print below:
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
Solved! Go to Solution.
11-07-2014 10:06 AM
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.
11-07-2014 06:41 AM
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.
11-07-2014 08:50 AM
Sorry, I did not understand.
11-07-2014 10:06 AM
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.
11-17-2014 07:50 AM
Thanks Marianne