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 number
IT37930
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A17
Status
CLOSED DOC
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-08-09
Closed date
2021-09-22
Last modified date
2021-09-22
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A17","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 January 2024