IT34736: MICROSOFT SQL SERVER DATABASES IN AN AAG ARE NOT AVAILABLE FOR SLA SCHEDULED BACKUPS OR AD HOC BACKUPS.

APAR status

• Closed as program error.

Error description

• When adding a Microsoft SQL Server database to an SLA or ad hoc
  backup, IBM Spectrum Protect Plus does not display databases
  that are in an Always On Availability Group (AAG). These
  databases cannot be backed up.
  
  | MDVREGR 10.1.5.0-TIV_5737SPLUS |
  
  
  IBM Spectrum Protect Plus Versions
  Affected:
  IBM Spectrum Protect Plus 10.1.6
  
  Initial Impact:
  Medium
  
  Additional Keywords: SPP, SPPlus, TS004352999, MSSQL,
  MS,
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levels 10.1.4, 10.1.5, 10.1.6, and *
  * 10.1.7.                                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * levels 10.1.7 ifix2 and 10.1.8. Note that this is subject to *
  * change at the discretion of IBM.                             *
  ****************************************************************
  

Problem conclusion

• An enhancement was made to remove the case sensitivity of a
  query to an SQL server.
  

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