IT43333: SQL log backup failure CTGGA3276 .. 'SqlLogBackup.IdentifiableSqlExecutionFailureException'

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus protection of a Microsoft SQL log can
  stop with the error seen in the job log:
  ERROR .. CTGGE1084,[<SQLServerAddress>]
                     SQL Server failed to backup logs for database
                     [<DBName>] on instance [<SQLInstanceName>] in
                     availability group [<SQLAAGName>].
                     The Event ID associated with the failure is
                     [512].
                     Check the event viewer on the server for
                     additional details.
   WARN .. CTGGA3277,[<SQLServerAddress>] Log backup status was
                     reported as partial: null
  ERROR .. CTGGA3276,Log backup failed for database
                     <SQLServerAddress>-><SQLInstanceName>
                     -><DBName>:
                     Exception of type 'SqlLogBackup.
                     IdentifiableSqlExecutionFailureException'
                     was thrown.
  
  This happens when the backup process cannot determine the
  expected preferred Microsoft SQL node set for backups in the
  Microsoft SQL Management Studio.
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.2 and later
  
  Additional Keywords: SPP, SPPLUS, TS011996375, MSSQL, logbackup
  

Local fix

• Ensure the desired preferred node for backups is set in the
  Microsoft SQL configuration.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus 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 10.1.15.  *
  * Note that this is subject to change at the discretion of IBM *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed so that when SQL preferred alwayons
  database query fails during SQL log backup, a clear message is
  reported.
  

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