Fixes are available
APAR status
Closed as program error.
Error description
Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server is not able to perform a restore to alternate location of an AlwaysOn database which was backed up using a non-readable secondary replica. The restore fails showing following messages in tdpsql.log: ACO5436E A failure occurred on stripe number (0), rc = 428 ACO5436E The SQL server aborted the operation. Restore of AAGDB failed. An exception occurred while executing a Transact-SQL statement or batch. The file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AAGDB.mdf' cannot be overwritten. It is being used by database 'AAGDB'. This problem only occurs if the backup of this database was taken from a non-readable secondary replica. Customer/L2 Diagnostics: The problem is Data Protection for SQL Server cannot read the file information of AlwaysOn databases from a non-readable secondary replica. A tdpsqlc query sql command will also return no file sizes for these databases: tdpsqlc query sql * /sqlserver=Non-readable-AlwaysOnInstance SQL Server Name .... Non-readable-AlwaysOnInstance SQL Database Name ........................ AAGDB SQL Database AAG Name ........... ........ AAG SQL Database Replica Role .. ............. Secondary SQL Database Sync State Description ...... Synchronized SQL Database Data Space Allocated ........ 0 SQL Database Data Space Used ............. 0 SQL Database Log Space Allocated ......... 0 SQL Database Log Space Used .............. 0 SQL Database Options ..................... Tivoli Storage Manager Versions Affected: Tivoli Storage Manager for Databases Version 6.4 and 7.1: Data Protection for Microsoft SQL Server Initial Impact: Medium Additional Keywords: TSM High Availability Primary AAG groups replication relocate position path directory
Local fix
The database can be restored into original location without any problem. Enable secondary replicas for readable access to prevent from this situation.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of: * * Tivoli Storage FlashCopy Manager for Microsoft SQL Server * * 3.2, 4.1.2, 4.1.3.0, * * Tivoli Storage Manager for Databases: Data Protection for * * Microsoft SQL Server 6.4, 7.1.2, 7.1.3.0 * * that perform backups of availability databases on * * non-readable secondary replica * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This fix is currently * * projected to be available in: * * Tivoli Storage FlashCopy Manager for Microsoft SQL Server * * 4.1.4 * * Tivoli Storage Manager for Databases: Data Protection for * * Microsoft SQL Server 7.1.4 * * Note : This information is subject to change at the * * discretion of IBM. * ****************************************************************
Problem conclusion
Tivoli Storage FlashCopy Manager for Microsoft SQL Server andTivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server have been updated to inform the user that the backup was taken on a non-readable secondary replica and restore wilth relocation is not possible. Also the following limitation has been added: ------------------- If a legacy backup of availability database has been taken on a non-readable secondary replica, restore from such a backup with database files relocation is not possible . Workaround: If the backed up database doesn't exist on the current server, try restoring to the original location. If the backed up database exists on the current server, move the existing db files to any different location and try restoring the backup as a new database. The database files will be placed to the original location. ------------------
Temporary fix
Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server 6.4.1.8, 7.1.3.1
Comments
APAR Information
APAR number
IT08974
Reported component name
TDP FOR SQL WIN
Reported component ID
5698DPSAP
Reported release
64W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-05-22
Closed date
2015-09-10
Last modified date
2015-09-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FCM tdpsqlc
Fix information
Fixed component name
TDP FOR SQL WIN
Fixed component ID
5698DPSAP
Applicable component levels
R64W PSY
UP
R71W PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.4","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
07 January 2022