IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT41929

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A19

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-09-01

  • Closed date

    2022-09-08

  • Last modified date

    2022-09-08

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A19","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
01 February 2024