IT38606: SQL BACKUP FAILURE: THE FILENAME, DIRECTORY NAME, OR VOLUME LABEL SYNTAX IS INCORRECT

APAR status

• Closed as program error.

Error description

• Error Description:
  IBM Spectrum Protect Plus backups of Microsoft SQL Server
  databases may fail with the error message below.
  This error is due to an extra slash in the database file path.
  
  ERROR,<timestamp> UTC,2,CTGGA3152,[<DBServerHost>] The
  validation of the shadow copy device [\\?\GLOBALROOT\Device\Har
  ddiskVolumeShadowCopy34\ProgramData\SQLData\archive\log\<DBName
  >.ldf]failed with error: [The filename  directory name  or volum
  label syntax is incorrect].
  ERROR,<timestamp> UTC,2,CTGGA3090,[<DBServerHost>] Group
  WN67150\<DBName> copy failed. Error: [The source file [\\?\GLOB
  ALROOT\Device\HarddiskVolumeShadowCopy34\ProgramData\SQLData\ar
  chive\log\<DBName.ldf]validation failed. Reason: [The filename
  volume label syntax is incorrect]]
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.x                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.9.                                                      *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• Made enhancements to handle additional \ characters in the file
  paths. After applying the fix the backup job will complete for
  databases with file paths that have additional \ characters in
  them.
  

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

• Apps     SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels