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

IBM Tivoli Storage Manager (TSM) Client 7.1.1 Downloads and READMEs
Download Information: Version 4.1.1 Tivoli Storage FlashCopy Manager

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 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