IBM Support

IC95612: DP FOR SQL VSS RESTORE AGAINST A DATABASE IN USE OVERWRITES EXISTING DATABASE FILES WITHOUT WARNING INSTEAD OF FAILING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When performing a VSS restore using Tivoli Storage Manager for
    Databases: Data Protection for Microsoft SQL Server, VSS
    backups must be restored to the same SQL server instance where
    the snapshot was taken.
    Unless the RELOCATE option is used during the VSS database
    restore process, the existing data is overwritten by the
    restored data and is no longer available after the restore is
    complete.
    Additionally, the restore command documentation indicates the
    following:
     "You cannot restore SQL databases currently in use. By placing
     SQL databases to be restored in single-user mode, you can avoid
     attempting such restores."
    Therefore, when attempting a VSS restore, without using the
    RELOCATE option, against an SQL database that is in use, the
    process should fail.
    However, the actual behavior is that the process completes with
    a success indicator and the changes do not take effect until
    the system is rebooted.
    The Data Protection SQL tracings shows:
     07/17/2013 10:33:32.496 [009576] [14840] :
     ..\..\common\winnt\osutl.cpp(1364): psReplaceOnReboot():
     Replace'C:\Program Files\Microsoft SQL
     Server\MSSQL.1\MSSQL\Data\$TSMInUse.1374071612.56.01.testdb.mdf
     -> 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
     testdb.mdf' at system reboot
     07/17/2013 10:33:32.500 [009576] [14840] :
     ..\..\common\winnt\osutl.cpp(1460): psReplaceOnReboot():
     'C:\Program Files\Microsoft SQL
     Server\MSSQL.1\MSSQL\Data\testdb.mdf' will be replaced at
     system reboot
    .
    Initial Impact:  High
    Additional Keywords: TSM FCM TDP DP FlashCopy
    

Local fix

  • Use the RELOCATE option when restoring a Data Protection for SQL
    VSS  backup so that the original database is not overwritten.
    To replace the original database, ensure that the SQL database
    being restored is in single-user mode.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Microsoft SQL Server with                    *
    *                 Tivoli Storage FlashCopy Manager VSS         *
    *                 Requestor 2.1, 2.2, 3.1, 3.2, and 4.1.0      *
    *                 on all Microsoft Windows platforms           *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be         *
    *                 fixed in:                                    *
    *                                                              *
    *                 Tivoli Storage Manager 6.4.2 and 7.1.1       *
    *                 Tivoli Storage FlashCopy Manager VSS         *
    *                 Requestor 4.1.1                              *
    *                                                              *
    *                 Note: This information is subject to         *
    *                 change at the discretion of IBM.             *
    ****************************************************************
    *
    

Problem conclusion

  • The problem has been corrected such that the restore behavior
    matches the documentation.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC95612

  • Reported component name

    TDP FOR SQL WIN

  • Reported component ID

    5698DPSAP

  • Reported release

    63W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-29

  • Closed date

    2014-01-24

  • Last modified date

    2014-05-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • DSMAGENT FCM      MMC
    

Fix information

  • Fixed component name

    TSM CLIENT

  • Fixed component ID

    5698ISMCL

Applicable component levels

  • R64W PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63W

Reference #: IC95612

Modified date: 11 May 2014