Why am I having issues restoring a Full+Diff? SQL Backup exit code: 790 // SQL error code: 3136

KE_JOSH

I'm able to restore the FULL just fine, and I restore it in NORECOVERY of course. Once the full is complete, it errors out when moving onto the differential. This always happens and I've not been able to restore a differential at all. Kind of pointless software if I'm not able to do so. I'm on version 9.2.7.543

keec-tsx: Restore - Failed<br>==========================<br><br>Restoring differential backup - Failed<br>--------------------------------------<br><br>This operation failed with errors.<br><br>Restoring NGDevl (database) from:<br>C:\Temp\DIFF_(local)_NGProd_20181003_203000.sqb<br>Thread 0 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 1 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 2 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 3 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 4 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 5 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 6 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 7 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 8 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 9 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 10 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 11 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 12 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 13 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 14 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>Thread 15 error:<br>Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)<br>SQL error 3013: RESTORE DATABASE is terminating abnormally.<br>SQL error 3136: This differential backup cannot be restored because the database has not been restored to the correct earlier state.<br>SQL Backup exit code: 790<br>SQL error code: 3136

Dan B

Hi KE-Josh,

Thanks for posting on the redgate forum. Are you able to send over the full Script being run to restore the FULL and the script being run to restore the DIFF and ideally the logs for both. You can send this to support@red-gate.com if you would prefer to keep this information private.