IT37930: LOG TRUNCATION OPTION IN VM BACKUP JOB NEEDS TO BE DISABLED TO PREVENT SQL LSN DISCONTINUITY

APAR status

• Closed as documentation error.

Error description

• It is possible that the same databases that are on a VM might be
  backed up with IBM Spectrum Protect Plus as part of a VM backup
  job and a SQL Server backup job. If Truncate SQL logs option is
  selected for the VM backup and log backup is enabled for the SQL
  backup, this can trigger the alert of LSN discontinuity as
  following:
  
  Break in transaction log backup chain for database [sql-db] on
  [sql-server] detected. PIT restores may not work. Check
  msdb.dbo.backupset on instance to confirm.
  
  IBM Spectrum Protect Plus manual Installation and User's Guide,
  Chapter 15. Protecting databases, section "SQL Server -> Backing
  up SQL Server data -> Enable Log Backup" needs to be updated to
  include the restriction that Truncate SQL logs option is not
  selected for a VM backup job that backs up the same databases.
  
  https://www.ibm.com/docs/en/spp/10.1.8?topic=server-backing-up-
  sql-data
  

Local fix

• If you want to enable log backup for a SQL Server backup job,
  ensure that Truncate SQL logs option is not selected for a VM
  backup job that backs up the same databases.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus version 10.1.7, 10.1.8, and 10.1.9 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• In the IBM Spectrum Protect Plus Knowledge Center and User's
  Guide version 10.1.7, 10.1.8, and 10.1.9 the following topics
  will be updated:
  
  
  https://ibmdocs-test.mybluemix.net/docs/en/spp/10.1.9?topic=vmwa
  re-backing-up-data
  https://ibmdocs-test.mybluemix.net/docs/en/spp/10.1.9?topic=serv
  er-backing-up-sql-data
  https://ibmdocs-test.mybluemix.net/docs/en/spp/10.1.9?topic=buss
  d-log-backups
  
  
  With the following restrictions
  vmware topic:
  
  
  Restriction: It is possible that the same databases that are on
  a VM might be backed up as part of a VM backup job and a SQL
  Server backup job. Do not select this option if you want to back
  up the database transaction logs during the SQL Server backup
  operation. The log truncation deletes all inactive logs from the
  log file. The deleted log sequence causes discontinuity in the
  log backup.
  
  For more information about backing up SQL Server database logs,
  see Log backups.
  
  
  sql and log topics:
  
  Restriction: It is possible that the same databases that are on
  a VM might be backed up as part of a VM backup job and a SQL
  Server backup job. If enable log backup for a SQL Server backup
  job, ensure that Truncate SQL logs option is not selected for a
  VM backup job that backs up the same databases. The log
  truncation deletes all inactive logs from the log file. The
  deleted log sequence causes discontinuity in the log backup.
  

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

Applicable component levels