IT40429: ENABLE LOG BACKUP FAILED FOR MS SQL DB. ERROR: 0X80131500

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus enabling the log backups for a
  Microsoft SQL Server database
  might fail with "Error: 0x80131500" if database was recreated or
  restored with restore lsn of older recovery greater than the
  latest recovery.
  
  The job log will display :
  Failed to enable log backup for [SQL INSTANCE] ==> [DATABASE
  NAME] [ Last run for database [DATABASE NAME] failed.]
  Failed to enable log backup for [SQL INSTANCE] ==> [DATABASE
  NAME] [ Last run for database [DATABASE NAME] failed.]
  Setting task status to partial for reasons: [Enable log backup
  failure(s)]
  ....
  Protection task [NUMBER] completed in [TIME DURATION] and ended
  with status PARTIAL|FAIL
  
  Affected versions: IBM Spectrum Protect Plus 10.1.10
  

Local fix

• n/a
  

Problem summary

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

Problem conclusion

• Query to find previous backups were changed to handle the cases
  where LSN number is less than older backups. After applying the
  fix log backups will continue after the database is restored or
  recreated.
  

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:

Modules/Macros

• Apps     SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels