IT13050: RESTORE FROM VMVSS BACKUP MAY FAIL WITH ANS1086E(RC104)

APAR status

• Closed as Permanent restriction.

Error description

• Tivoli Storage Manager for Virtual Environments: Data
  Protection for VMware provides in-guest database
  level recovery options for Microsoft SQL Server or Microsoft
  Exchange Server databases when one of the following
  products and components listed below is used for the
  restore process:
  - Tivoli Storage Manager for Databases:
    Data Protection for Microsoft SQL Server
  - Tivoli Storage Manager for Mail:
    Data Protection for Microsoft Exchange Server
  - Tivoli Storage FlashCopy Manager on Windows
  
  These Data Protection for VMware generated backups
  are displayed as VMVSS type in the MMC GUI of
  the product and component performing the restore operation.
  
  A restore of such a backup may fail with the following error
  messages:
  ============================================================
  Request             : VSS RESTORE
  Component List      : 'EXDB01\<SnapshotGUID>'(full, TSM)
  Local DSMAGENT Node : EX1
  Mount Wait          : Yes
  ------------------------------------------------------------
  Backup to be restored:
  <EXDB01\<SnapshotGUID> : VMVSS : full : 01/06/2016 11:15:00>
  Restoring 'EXDB01' via file-level copy from snapshot(s).
    This process may take some time. Please wait.
  ANS1086E (RC104)  File not found during Backup, Archive or
    Migrate processing
  ACN5060E A Tivoli Storage Manager API error has occurred.
    Examine the Windows Event Logs and DSMERROR.LOG for
    additional details.
  
  Customer/L2 Diagnostics:
  The problem is caused by the fact the disk numeration
  in Windows and VMWare are not in same order.
  
  It is expected that VMware's disk number
  is equal to 'Windows disk number + 1'.
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager for Virtual Environments:
  Data Protection for VMWare Version 7.1.X
  
  Initial Impact:
  Medium
  
  Additional Keywords:
  TSM Spectrum Protect TDP4VE tdpsql tdpexc IMR database-level
  VMWare ESXi isci
  

Local fix

• Make sure the VMWare disk numeration is equal to
  'Windows disk number + 1' or
  use the Recovery Agent of Data Protection for Virtual
  environments to manually mount the correct disk snapshot
  and copy the data with Windows Explorer to a local disk.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  * Tivoli Storage Manager for Virtual Environments 7.1,         *
  * who perform a VM backup with application protection and      *
  * restore MS SQL or Exchange database from the VM backup       *
  * using:                                                       *
  * -Tivoli Storage FlashCopy Manager for Microsoft Exchange     *
  * Server 4.1;                                                  *
  * -Tivoli Storage Manager for Mail: Data Protection Microsoft  *
  * Exchange Server 7.1;                                         *
  * -Tivoli Storage FlashCopy Manager for Microsoft SQL Server   *
  * 4.1;                                                         *
  * -Tvoli Storage Manager for Databases: Data Protection for    *
  * Microsoft SQL Server 7.1.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This is a limitation of current implementation. A workaround *
  * can be found in "Restore of a Microsoft SQL Server or        *
  * Exchange Server database from a VM backup with application   *
  * protection might fail with messages ANS1086E and ACN5060E."  *
  * section for the following documents:                         *
  *  - Known Issues and Limitations: Version 4.1.x IBM Spectrum  *
  * Protect? Snapshot for Microsoft SQL & Version 7.1.x Data     *
  * Protection for Microsoft SQL (                               *
  * http://www.ibm.com/support/docview.wss?uid=swg21644478 )     *
  *  - Known Issues and Limitations: Version 4.1.x IBM Spectrum  *
  * Protect? Snapshot for Microsoft Exchange & Version 7.1.x     *
  * Data Protection for Microsoft Exchange (                     *
  * http://www.ibm.com/support/docview.wss?uid=swg21644481 )     *
  *  - Known Issues and Limitations: V7.1 IBM Spectrum Protect   *
  * for Virtual Environments: Data Protection for VMware (       *
  * http://www.ibm.com/support/docview.wss?uid=swg21640744 )     *
  ****************************************************************
  

Problem conclusion

• The problem has been documented as a limitation "Restore of a
  Microsoft SQL Server or Exchange Server database from a VM
  backup with application protection might fail with messages
  ANS1086E and ACN5060E." in the following documents:
   - Known Issues and Limitations: Version 4.1.x IBM Spectrum
  Protect? Snapshot for Microsoft SQL & Version 7.1.x Data
  Protection for Microsoft SQL  (
  http://www.ibm.com/support/docview.wss?uid=swg21644478 )
   - Known Issues and Limitations: Version 4.1.x IBM Spectrum
  Protect? Snapshot for Microsoft Exchange & Version 7.1.x Data
  Protection for Microsoft Exchange (
  http://www.ibm.com/support/docview.wss?uid=swg21644481 )
   - Known Issues and Limitations: V7.1 IBM Spectrum Protect for
  Virtual Environments: Data Protection for VMware (
  http://www.ibm.com/support/docview.wss?uid=swg21640744 )
  

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

• tdpsqlc  tdpexcc  fcm      dsmc
  

Fix information

Applicable component levels