IBM Support

SQL database restore fails with earlier state error message

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.
[{"Product":{"code":"SSER7G","label":"IBM Spectrum Protect for Databases"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Protection for MS SQL","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.3;7.1.4;7.1.6","Edition":"","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

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

Manage My Notification Subscriptions