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

Restore Error

ToehoToeho Posts: 73
edited October 27, 2008 11:07PM in SQL Backup Previous Versions
Getting the folowing error when trying to restore a database. I am using Sql Backup 5.3.

SQL Backup log file 5.3.0.178

-SQL "RESTORE DATABASE [prod] FROM DISK = 'F:\Temp\FULL_(local)_prod_20081022_073039_2.sqb', DISK = 'F:\Temp\FULL_(local)_prod_20081022_073039_1.sqb' WITH RECOVERY, MOVE 'prod_Data' TO 'f:\MSSQL\Data\prod_data.mdf', MOVE 'prod_Log' TO 'f:\MSSQL\Data\prod_log.ldf', PASSWORD = 'XXXXXXXXXXXX' "

ERRORS AND WARNINGS


10/27/2008 8:38:51 AM: Restoring prod (database) from:
10/27/2008 8:38:51 AM: F:\Temp\FULL_(local)_prod_20081022_073039_2.sqb
10/27/2008 8:38:51 AM: F:\Temp\FULL_(local)_prod_20081022_073039_1.sqb

10/27/2008 8:38:53 AM: RESTORE DATABASE [prod] FROM VIRTUAL_DEVICE = 'SQLBACKUP_AD4C76D5-ABF5-43D6-95CD-6FA1E0FC7A35', VIRTUAL_DEVICE = 'SQLBACKUP_AD4C76D5-ABF5-43D6-95CD-6FA1E0FC7A3501' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'prod_Data' TO 'f:\MSSQL\Data\prod_data.mdf', MOVE 'prod_Log' TO 'f:\MSSQL\Data\prod_log.ldf'

10/27/2008 8:49:16 AM: Thread 0 error:
Data decompression error: ZLib decompression error: data error
Process terminated unexpectedly. Error code: -2139684860
10/27/2008 8:49:16 AM:
10/27/2008 8:49:16 AM: Thread 1 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
10/27/2008 8:49:16 AM:
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3270: SQL error 3270: An internal consistency error occurred. Contact Technical Support for assistance.
SQL error 3203: SQL error 3203: Read on 'SQLBACKUP_AD4C76D5-ABF5-43D6-95CD-6FA1E0FC7A3501' failed, status = 995. See the SQL Server error log for more details.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    The error suggests that the file is incomplete or corrupted.

    If this file was copied, I would suggest comparing against the original file e.g. using a MD5 file checksum generator. I would also check if any errors were recorded during the creation of this backup file.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.