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

Data decompression error: file may be corrupted

gabreu2gabreu2 Posts: 2
edited January 9, 2009 5:17AM in SQL Backup Previous Versions
hi, could you help me with this error, i backup a database and copy the backup file to an external disk, then copy again in another server and when try to restore i got the following error: (below is the log of backup operation)

Restoring full backup - Failed

This operation failed with errors.

Restoring DSS (database) from:
f:\data\FULL_(local)_DSS_20081125_084845.sqb
Thread 0 error:
Data decompression error: file may be corrupted
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_A9F5FFFE-5021-4466-8CD4-F88175BA5BF6' is incorrectly formed. SQL Server cannot process this media family.
SQL Backup exit code: 790
SQL error code: 3241


***********************************
SQL Backup log file 5.3.0.178

-SQL "BACKUP DATABASE [DSS] TO DISK = '\\10.171.2.34\shares\prod\temp\<AUTO>.sqb' WITH COMPRESSION = 1 "

PROCESSES COMPLETED SUCCESSFULLY

11/25/2008 8:48:43 AM: Backing up DSS (full database) to:
11/25/2008 8:48:43 AM: \\10.171.2.34\shares\prod\temp\FULL_(local)_DSS_20081125_084843.sqb

11/25/2008 8:48:47 AM: BACKUP DATABASE [DSS] TO VIRTUAL_DEVICE = 'SQLBACKUP_9A7D3B31-78B9-4E96-AF33-EDE30B6EE89C' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (DSS), 11/25/2008 8:48:45 AM', DESCRIPTION = N'Backup on 11/25/2008 8:48:45 AM Server: POS1NB07 Database: DSS'

11/25/2008 9:51:47 AM: Database size : 241.937 GB
11/25/2008 9:51:47 AM: Compressed data size: 32.712 GB
11/25/2008 9:51:47 AM: Compression rate : 86.48%

Processed 31438928 pages for database 'DSS', file 'DSS_Data' on file 1.
Processed 3 pages for database 'DSS', file 'DSS_1_Log' on file 1.
BACKUP DATABASE successfully processed 31438931 pages in 3780.162 seconds (68.131 MB/sec).
11/25/2008 9:51:47 AM: SQL Backup process ended.

Comments

  • Options
    Hi gabreu2,

    It seems that somewhere a long the way the backup files has been corrupted.

    Form what I can tell, you are backing up to a network share, copying the file to an external disk and then copying it to the server you wish to perform the restore?

    The first step will be to determine if the backup was corrupted in the initial backup or if it has been corrupted in one of the copies. Can you please try the following :

    Download the following command line application from here which will create a md5 hash.

    You should then use the application to create a md5 hash for both the original file on your network share and the file you are trying to restore. If the numbers are identical we can assume the original backup was corrupted at some point. If the numbers are different, you could try copying the file again to see if it can restore.

    The command is simple, you simply open a command prompt and use the syntax of md5x "C:\backups\backupfile.sqb"

    Please let me know how you get on.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.