IT28560: DATA PROTECTION FOR SQL PARTIAL RESTORE TO ALTERNATE LOCATION REPEATS FIRST BATCH UNTIL IT ENDS MISTAKENLY WITH RC=0

Download Information: Version 8.1.8 IBM Spectrum Protectâ„¢ for Databases
Download Information: Version 8.1.8 IBM Spectrum Protect Snapshot

APAR status

• Closed as program error.

Error description

• When using the Spectrum Protect for Databases, Data Protection
  for MS SQL for a partial restore to an alternate location it
  completes successfully, and the tdpsql.log shows in the File
  Input List and Relocate Input List all of the different files
  listed in the batches.  However, a listing of files in the
  relocation directory only shows files from the first batch of
  the partial restore.  A data protection trace of the restore
  shows the reason is because there is no filegroup set:
  03/16/2019 11:03:26.256 : sqlapi.cpp (5169): sqlWideCmdP : USE
  master RESTORE DATABASE [IBM_20181125] <no FILEGROUP= part> from
  VIRTUAL_DEVICE=N'TDPSQL-00006F20-0000' WITH BLOCKSIZE=512,
  MAXTRANSFERSIZE=1048576, PARTIAL.....
  As a result, only the primary files in the first batch were
  repeatedly selected for restore.  Running a partial restore
  specifying filenames like 'tdpsqlc restore dbname full /partial
  /file=<list of files>' ignores the filenames and defaults to the
  filegroup.
  IBM Spectrum Protect for SQL Versions Affected:  all
  Initial Impact: Low
  Additional Keywords:  TSM TDP "Partial restore" TS001801183
  relocate
  

Local fix

• None for restore.  Ensure filegroups are set during backup.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Tivoli Storage Manager for Databases and IBM Spectrum    *
  * Protect                                                      *
  *  for Databases                                               *
  * Data Protection for Microsoft SQL Server versions 7.1 and    *
  * 8.1                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This fix is currently     *
  * projected to be available in the next targeted release.      *
  * Note that this information is subject to change at the       *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Data Protection for Microsoft SQL Server has been updated to
  support partial restore based on file option.
  

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:

Fix information

• Fixed component name

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels