Red Gate forums :: View topic - Restores failing with exit code 790
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Restores failing with exit code 790

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Thu Jan 10, 2013 4:11 pm    Post subject: Restores failing with exit code 790 Reply with quote

I can't do a restore that includes full/diff/logs. I get sql error 3136 This differential cannot be restored because the database has not been restored to the correct earlier state. This happened after updating to 7.2.0.286 I'm really in a pickle here.
Back to top
View user's profile Send private message
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Thu Jan 10, 2013 5:58 pm    Post subject: Reply with quote

Seems to be related to Differential restores. A full with logs will restore.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Jan 16, 2013 1:44 pm    Post subject: Reply with quote

Is it possible that the differential backup requires a different full backup, and not the one you restored?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Wed Jan 16, 2013 2:34 pm    Post subject: Reply with quote

Any insight? My backups are pretty much useless at this point.
Back to top
View user's profile Send private message
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Wed Jan 16, 2013 2:42 pm    Post subject: Reply with quote

Here's the error in detail.

Dev-Thor: Restore - Failed
==========================

Restoring full backup - Successful
----------------------------------

This operation completed successfully.

Restoring RIP_Onyx (database) from:
\\redgate1\SQLBackups\thor\Onyx\FULL_Onyx_20130113_025441.sqb
Processed 4387672 pages for database 'RIP_Onyx', file 'Vanilla500054_Data' on file 1.
Processed 9 pages for database 'RIP_Onyx', file 'Vanilla500054_Log' on file 1.
RESTORE DATABASE successfully processed 4387681 pages in 470.348 seconds (72.879 MB/sec).
SQL Backup process ended.



Restoring differential backup - Failed
--------------------------------------

This operation failed with errors.

Restoring RIP_Onyx (database) from:
\\redgate1\SQLBackups\thor\Onyx\DIFF_Onyx_20130116_023012.sqb
Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3136: SQL error 3136: This differential backup cannot be restored because the database has not been restored to the correct earlier state.
SQL Backup exit code: 790
SQL error code: 3136



Updating SQL Server information - Pending
-----------------------------------------

Operation pending.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Jan 16, 2013 4:01 pm    Post subject: Reply with quote

Could you please run this query on the instance where the backup was taken?

Code:
SELECT d.physical_device_name
FROM msdb..backupset a
INNER JOIN msdb..backupset b ON a.database_backup_lsn = b.checkpoint_lsn
INNER JOIN msdb..backupmediafamily c ON a.media_set_id = c.media_set_id
INNER JOIN msdb..backupmediafamily d ON b.media_set_id = d.media_set_id
WHERE c.physical_device_name LIKE '%DIFF_Onyx_20130116_023012.sqb'

This query should tell you the full backup set that the differential backup requires.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Wed Jan 23, 2013 3:54 pm    Post subject: Reply with quote

Ok, I had a chance to try again. The restore is only 2 files, a full backup from sunday and last nights diff. Here's the error and the results of the query you wanted me to run with the current diff.

Dev-Thor: Restore - Failed
==========================

Restoring full backup - Successful
----------------------------------

This operation completed successfully.

Restoring RIP_Onyx (database) from:
\\redgate1\SQLBackups\thor\Onyx\FULL_Onyx_20130120_025056.sqb
Processed 4396432 pages for database 'RIP_Onyx', file 'Vanilla500054_Data' on file 1.
Processed 17 pages for database 'RIP_Onyx', file 'Vanilla500054_Log' on file 1.
RESTORE DATABASE successfully processed 4396449 pages in 469.187 seconds (73.205 MB/sec).
SQL Backup process ended.



Restoring differential backup - Failed
--------------------------------------

This operation failed with errors.

Restoring RIP_Onyx (database) from:
\\redgate1\SQLBackups\thor\Onyx\DIFF_Onyx_20130123_023009.sqb
Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3136: SQL error 3136: This differential backup cannot be restored because the database has not been restored to the correct earlier state.
SQL Backup exit code: 790
SQL error code: 3136



Updating SQL Server information - Pending
-----------------------------------------

Operation pending.


SELECT d.physical_device_name
FROM msdb..backupset a
INNER JOIN msdb..backupset b ON a.database_backup_lsn = b.checkpoint_lsn
INNER JOIN msdb..backupmediafamily c ON a.media_set_id = c.media_set_id
INNER JOIN msdb..backupmediafamily d ON b.media_set_id = d.media_set_id
WHERE c.physical_device_name LIKE '%DIFF_Onyx_20130123_023009.sqb'

Results

physical_device_name
{E2E5B7E6-6FD4-415D-8989-36FAD01A243E}14
d:\temp\Onyx\LOG_Onyx_20130122_190001.sqb
NUL
d:\temp\Onyx\LOG_Onyx_20130122_191501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_193001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_194501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_200001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_201501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_203001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_204501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_210001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_211501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_213000.sqb
d:\temp\Onyx\LOG_Onyx_20130122_214501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_220001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_221501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_223000.sqb
d:\temp\Onyx\LOG_Onyx_20130122_224501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_230001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_231501.sqb
d:\temp\Onyx\LOG_Onyx_20130122_233001.sqb
d:\temp\Onyx\LOG_Onyx_20130122_234500.sqb
Back to top
View user's profile Send private message
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Wed Jan 23, 2013 7:31 pm    Post subject: I believe I've figured it out. Reply with quote

You may be interested in this. Here's the problem. http://support.microsoft.com/default.aspx?scid=kb;EN-US;937683

Veeam, our virtual backup software has been writing to the msdb database after a filesystem backup. I just did a full backup and then a diff and the restore worked.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Thu Jan 24, 2013 1:45 am    Post subject: Reply with quote

Thanks for the update. I was wondering about the '{E2E5B7E6-6FD4-415D-8989-36FAD01A243E}14' device name.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
brosato



Joined: 03 Oct 2008
Posts: 73

PostPosted: Thu Jan 24, 2013 2:49 pm    Post subject: Reply with quote

Seems that veeam is causing all kinds of problems on our servers.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group