IT14714: VERIFYONLY RESTORE ERRONEOUSLY REMOVES DATABASE FROM ALWAYSON AVAILABILITY GROUP

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

APAR status

• Closed as fixed if next.

Error description

• It is possible to test the integrity of a legacy backup with
  Tivoli Storage Manager for Databases: Data Protection for
  Microsoft SQL Server.
  
  This is done either in the MMC GUI with restore option
  Verify Only
  
  or from command line:
  tdpsqlc restore MYDB FULL /VerifyOnly
  
  In case the database which should be tested is part of an
  AlwaysOn availability group (AAG) this database is erroneously
  removed from the AAG and left as stand alone database.
  
  Customer/L2 Diagnostics:
  A service trace of a verifyonly restore shows that the
  database is removed from AAG:
  SqlApi.cpp(11083): RemoveDBFromAvailabilityGroup(): Removed DB
  with T-SQL = use master;ALTER AVAILABILITY GROUP [<AAGName>]
  REMOVE DATABASE [<DBName>];
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager for Databases Version 7.1.1 to 7.1.4:
  Data Protection for Microsoft SQL Server.
  
  Initial Impact:
  Low
  
  Additional Keywords:
  TSM ISP spectrum protect High availability VDI Cluster
  

Local fix

• Add the database to AAG after restore operation again:
  ALTER AVAILABILITY GROUP <AAGName> ADD DATABASE <DBName>;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  * Tivoli Storage Manager for Databases Data Protection for     *
  * Microsoft SQL version 7.1.0 and higher                       *
  * Tivoli Storage FlashCopy Manager for Microsoft SQL  version  *
  * 4.1.0 and higher                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available.                           *
  ****************************************************************
  

Problem conclusion

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

• tdpsqlc
  

Fix information

Applicable component levels

• R71W PSY

     UP