IT41929: SQL RESTORE LEAVES A "RESTORING..." DATABASE WHEN DESTINATION VOLUME DOES NOT HAVE SUFFICIENT SPACE

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus SQL database restore fails with
  "Insufficient space" and leaves a "Restoring..." database when
  destination volume does not have sufficient space. The job log
  shows:
  
  CTGGA3034,[sql-server] Failed to restore database. Error: Writer
  [SqlServerWriter] reported error
  status([VSS_WS_FAILED_AT_POST_RESTORE]  [14])  error message
  [(0x00000000  00000011E0142A70)]
  CTGGA3035,[sql-server] Database restore complete. The database
  is in the restoring state
  
  The status of "Restoring..." database can be seen in SQL
  Management Studio. As a result, the subsequent restore fails
  because SQL database is in restoring status. The error handling
  should fail restore in an early stage right after space
  validation error, so restoring database is not created.
  
  Versions affected: 10.1.*
  
  Additional Keywords: SPP, SPPLUS, TS009636881
  

Local fix

• Manually delete the Restoring... database through SQL server
  side, like SQL Management Studio
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *  IBM Spectrum Protect Plus level 10.1.9, 10.1.10 and 10.1.11 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level        *
  * 10.1.12. Note that this is subject to change at the          *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Added space checking for restore. After applying the fix the
  restore job will fail without leaving the database in restoring
  state if there is not enough free space.
  

Temporary fix

• Manually delete the database that is in the restoring state.
  

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