What are the challenges you face when working across database platforms? Take the survey
Options

Restore quits after 45 minutes

bkdeslerbkdesler Posts: 3
edited March 24, 2011 5:35PM in SQL Backup Previous Versions
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.)

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks. Checksums are different. Must be losing something when I move the compressed backup file from one server to another.
Sign In or Register to comment.