Restore quits after 45 minutes

bkdesler

Hello -

Trying to restore from a compressed SQL Backup file. Restore quits after about 45 minutes. Below is log. Restore gets about 8GB into a 58GB backup file. Can someone please help. Thanks in advance.

SQL Backup log file 6.4.0.56

-SQL "RESTORE DATABASE [tankdata_kamps] FROM DISK = 'E:\DatabaseFiles\tankdata_kamps-20110320 0345-FULL.sqb' WITH RECOVERY, MOVE 'tankdata_kamps_data' TO 'E:\DatabaseFiles\tankdata_kamps.mdf', MOVE 'tankdata_kamps_log' TO 'E:\DatabaseFiles\tankdata_kamps_l
og.ldf', ORPHAN_CHECK "

---

ERRORS AND WARNINGS

---

3/23/2011 11:13:34 AM: Restoring tankdata_kamps (database) from:
3/23/2011 11:13:34 AM: E:\DatabaseFiles\tankdata_kamps-20110320 0345-FULL.sqb

3/23/2011 11:13:34 AM: RESTORE DATABASE [tankdata_kamps] FROM VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A', VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A01', VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F5
0FE0C6A02', VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A03', VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A04', VIRTUAL_DEVICE = 'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A05', VIRTUAL_DEVICE =
'SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'tankdata_kamps_data' TO 'E:\DatabaseFiles\tankdata_kamps.mdf', MOVE 'tankdata_kamps_log' TO 'E:\DatabaseFiles\tankdata
_kamps_log.ldf'

3/23/2011 12:03:58 PM: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 1 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 5 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:58 PM: Thread 6 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)

Device index out of range: 20
3/23/2011 12:03:58 PM:
3/23/2011 12:03:59 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
3/23/2011 12:03:59 PM: SQL error 3203: SQL error 3203: Read on "SQLBACKUP_A7CFA862-EE97-4155-A299-E38F50FE0C6A" failed: 38(Reached the end of the file.)

petey

The error message suggests that the backup file is corrupted or incomplete. Could you please compare this file against the original copy e.g. by computing their md5 checksums?

Thanks.

bkdesler

Thanks. Checksums are different. Must be losing something when I move the compressed backup file from one server to another.