Troubleshooting
Problem
Attempting a SQL Server restore of a differential backup after successful completion of full backup restoration, fails with message "This differential backup cannot be restored because the database has not been restored to the correct earlier state."
Symptom
In the following example diffFull backup from "05/31/2016 23:30:43" was attempted to be restored, and full backup from "05/28/2016 08:30:53" was identified as its associated full backup within the Data Protection for MS SQL client.
Backup Object Information
-------------------------
SQL Server Name ........................ C64
SQL Database Name ........................ TESTDB
Backup Method ........................ Lgcy
Backup Location ........................ Srv
Backup Object Type ....................... Full
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 05/28/2016 08:30:53
Backup Size .............................. 285.10 MB
SQL Compressed ........................... No
Backup Compressed ........................ Yes
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20160528083053\0000212C
Number of stripes in backup object ....... 1
Assigned Management Class ............... MC_TEST
.
DiffFull backup:
Backup Object Information
-------------------------
SQL Server Name ........................ C64
SQL Database Name ........................ TESTDB
Backup Method ........................ Lgcy
Backup Location ........................ Srv
Backup Object Type ....................... DiffFull
Backup Object State ...................... Inactive
Backup Creation Date / Time .............. 05/31/2016 23:30:43
Backup Size .............................. 1.08 MB
SQL Compressed ........................... No
Backup Compressed ........................ Yes
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Database Object Name ..................... 20160531233043\00001F14
Number of stripes in backup object ....... 1
Assigned Management Class ............... MC_TEST
The full backup was able to be restored successfully, however, diffFull restore failed with the following error witnessed In the tdpsql.log file:
06/08/2016 15:30:53 Request : RESTORE
06/08/2016 15:30:53 Database Input List : -
....
06/08/2016 15:30:53 Recovery : Yes
06/08/2016 15:30:53 Replace : Yes
06/08/2016 15:30:53 Restricted User Only? : No
06/08/2016 15:30:53 Partial? : -
06/08/2016 15:30:53 TSM Options File : C:\Program Files\Tivoli\TSM\TDPSql.opt
06/08/2016 15:30:53 TSM Nodename Override : -
06/08/2016 15:30:53 Fromsqlserver : C64
06/08/2016 15:30:53 Sqlserver : C64
06/08/2016 15:32:04 ACO5436E A failure occurred on stripe number (0), rc = 428
06/08/2016 15:32:04 ACO5407E The SQL server aborted the operation.
06/08/2016 15:32:04 Restore of TESTDB failed.
06/08/2016 15:32:04 An exception occurred while executing a Transact-SQL statement or batch.
06/08/2016 15:32:04 This differential backup cannot be restored because the database has not been restored to the correct earlier state.
06/08/2016 15:32:04 RESTORE DATABASE is terminating abnormally.
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
IBM Spectrum Protect for Databases
Software version:
7.1.3, 7.1.4, 7.1.6
Operating system(s):
Windows
Document number:
282935
Modified date:
17 June 2018
UID
swg21985827