IT29024: SQL FULL BACKUP FAILS DUE TO VDI PERMISSIONS ISSUE. AS A RESULT,SQL LOG BACKUP TERMINATES ABNORMALLY.

APAR status

• Closed as program error.

Error description

• To start doing log backups a one time full backup is required.
  Spectrum Protect Plus uses VDI functions to do the full
  backup. The full backup fails because of the VDI permissions
  issue on the server, like error 0x80070005. As a result,
  subsequent SQL log backup terminates abnormally with following
  error in command.log:
  
  [date time] JobLog 15900 Thread-1 agent_sql_log: Creating the
  target folder [\\xx.xxx.x.xx\vpool1_fsxx\<SQL DB Name>].
  [date time] JobLog 15900 Thread-1 agent_sql_log: Backing up the
  transaction log.
  [date time] JobLog 15900 Thread-1 agent_sql_log: Remaining
  space in backup staging directory
  [X:\MSSQL11.MSSQLSERVER\MSSQL\Backup\<SQL DB log folder>]:
  xx TB
  ...
  [date time] Warn 15900 Thread-1 agent_sql_log: Exception
  encountered while backing up transaction logs:
  Microsoft.SqlServer.Management.Common.ExecutionFailureException:
  An exception occurred while executing a Transact-SQL statement
  or batch. ---> System.Data.SqlClient.SqlException: BACKUP LOG
  cannot be performed because there is no current database backup.
  BACKUP LOG is terminating abnormally.
  
  There is no fallback approach in case SQL VDI fails.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.0, 10.1.1, 10.1.2 and   *
  * 10.1.3                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in 10.1.4. Note that this is subject   *
  * to change at the discretion of IBM                           *
  ****************************************************************
  

Problem conclusion

• A fall back method to perform the log backup is introduced if
  the preferred method fails.
  

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

• sqlagent
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels