IT44700: SQL BACKUP SOMETIMES REPORTS "FAILED TO ENABLE LOG BACKUP" IN A SQL SERVER ALWAYSON ENVIRONMENT

APAR status

• Closed as program error.

Error description

• SQL backup sometimes reports "Failed to enable log backup" in a
  SQL Server AlwaysOn environment
  
  
  Problem Description:
  In a SQL Server AlwaysOn environment, SQL databases sometimes
  reports "Failed to enable log backup":
  
  
  CTGGA2081,Failed to enable log backup for <SQL-AG-Name> ==>
  <SQL-DB-Name> [ Last run for database [SP_Social] failed.]
  
  
  The backup preferences is set on the AG level. The log backup
  is successful on one node, while fails on another non-backup
  node. The command.log shows following error:
  
  
  [date time] Debug 3848 Thread-10 agent_sql_log: Log Backup
  Exception full exception:
  SqlLogBackup.IdentifiableSqlExecutionFailureException: Exception
  of type 'SqlLogBackup.IdentifiableSqlExecutionFailureException'
  was thrown.
    at SqlLogBackup.SqlLogBackup.BackupLog(DatabaseInstanceEx
  database)
  ...
  [date time] Debug 3848 Thread-1 agent_sql_log: Result of DB:
  [SQL-DB-Name]; [FAILURE]
  
  
  The t-sql returns exception when trying to determine preferred
  replica on non-backup node.
  
  Versions affected: v10.1.*
  
  Additional keywords: TS013158733 SPP
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.16. Note that this is subject to change at the          *
  * discretion of IBM                                            *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed so that SQL log backup of alwayson
  databases can be completed successfully, as long as SQL T-SQL
  query "sys.fn_hadr_backup_is_preferred_replica" returns correct
  output.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels