IT10464: SQL DATABASE LEVEL RESTORES OF AN APPLICATION PROTECTION ENABLED VM FAILS TO RESTORE THE SQL DB BUT REPORTS SUCCESS VIA THE GUI.

IBM Spectrum Protectâ„¢ client 7.1.3.x interim fix downloads
IBM Spectrum Protectâ„¢ Client 7.1.4 Downloads and READMEs
Download Information: Version 4.1.4 IBM Spectrum Protectâ„¢ Snapshot
Download Information: Version 7.1.4 IBM Spectrum Protectâ„¢ for Databases

APAR status

• Closed as program error.

Error description

• When using Tivoli Storage Manager for Databases: Data Protection
  for Microsoft SQL Server to perform a database level restore of
   an application protection enabled VM backup that was created
  using Tivoli Storage Manager for Virtual Environments: Data
  Protection for VMware, the restore may report success but not
  actually restore the database to the SQL Server if the
  database is not the default SQL instance.
  
  Customer/L2 Diagnostics:
  
  When doing the restore via the Data Protection for Microsoft SQL
  GUI, it will report that the restore was successful.
  The Data Protection for VMware datamover will also will not
  report any errors and the Agent node will show that a number
  of files were restored and that the process was successful.
  
  However a SERVICE trace of the Agent Node (The Local BA Client
  node on the VM that contins the SQL server) will report,
  
  07/24/2015 16:44:20.326 [005304] [2660] :
  ..\..\common\winnt\vssreq.cpp(3346):
  VssRequestor::addRestoreFiles:
  thisPath=<SQLHOSTSYSTEM1\SQLTESTDB\SQLINST1>
  07/24/2015 16:44:20.326 [005304] [2660] :
  ..\..\common\winnt\vssreq.cpp(3347):
  VssRequestor::addRestoreFiles: fullPath=<SQLTESTDB\SQLINST1>
  
  These two paths should match.
  
  
  Tivoli Storage Manager for Databases Versions Affected:
  7.1.2
  Flash Copy Manager with Data Protection for SQL Versions
  Affected:
  4.1.2
  
  Initial Impact:
  Med
  
  Additional Keywords:
  FCM, Flash Copy, TDP, SQL, DPSQL, App, Database-Level Recovery
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  * - Tivoli Storage Manager (TSM) for Databases: Data           *
  * Protection for Microsoft SQL Server 7.1.2 - 7.1.3            *
  * - Tivoli Storage FlashCopy Manager for Microsoft SQL Server  *
  * 4.1.2 - 4.1.3                                                *
  *                                                              *
  * who restore a non-default SQL instance from an application   *
  * protection enabled VM backup created using                   *
  * Tivoli Storage Manager for Virtual Environments: Data        *
  * Protection for VMware                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This fix is projected to  *
  * be available in:                                             *
  *                                                              *
  * - Tivoli Storage Manager (TSM) Client 7.1.4, which is a      *
  * prerequisite to using TSM for Databases: Data Protection for *
  * Microsoft SQL Server                                         *
  * - FlashCopy Manager VSS Requestor 4.1.4                      *
  *                                                              *
  * Note 1: This information is subject to change at the         *
  * discretion of IBM.                                           *
  * Note 2: Until a FlashCopy Manager VSS Requestor fix is       *
  * available, FlashCopy Manager customers may install and use a *
  * fixed level of the TSM Client.                               *
  * When installed into a FlashCopy Manager on Windows           *
  * environment, the TSM Client fix provides the equivalent      *
  * functionality as the VSS Requestor.                          *
  ****************************************************************
  

Problem conclusion

• The software has been corrected to allow the restore of a
  non-default SQL instance from an application protection enabled
  VM backup created
   using Data Protection for VMware.
  

Temporary fix

• Tivoli Storage Manager Client 7.1.3.1 which is a prerequisite to
  using TSM for Databases: Data Protection for Microsoft SQL
  Server.
  

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

• dsmagnt
  

Fix information

• Fixed component name

  TSM CLIENT

• Fixed component ID

  5698ISMCL

Applicable component levels

• R71W PSY

     UP