How can we help you today? How can we help you today?

log shipping error on restore(SQL Backup version 5.2.0.2825)

Hello,

I am trying to set up log shipping and below is the error I get. The actual size of the database at the source machine(Glendale) is 75GB.

I am restoring the database in D:\ at the destination machine. I have verified that the D: on the destination machine(DRGlendale) has 90GB free and the C: has 6 GB free.

Please advise why would this be happening? Does the logshipping process temporarily decompress in the C: by default?

Thanks,


Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed with warnings.
Backing up CTSY2K (full database) to:
D:\Program Files\Microsoft SQL Server\MSSQL\Backup\CTSY2KV1\SEED_CTSY2K_20091020113156.sqb
Database size : 74.943 GB
Compressed data size: 6.574 GB
Compression rate : 91.23%
Processed 4581464 pages for database 'CTSY2K', file 'CTSY2K_dat' on file 1.
Processed 47 pages for database 'CTSY2K', file 'CTSY2K_log' on file 1.
BACKUP DATABASE successfully processed 4581511 pages in 318.972 seconds (117.664 MB/sec).
Warning 141: COPYTO error: Unable to copy D:\Program Files\Microsoft SQL Server\MSSQL\Backup\CTSY2KV1\SEED_CTSY2K_20091020113156.sqb to \\drGlendale\CTSY2KV1\SEED_CTSY2K_20091020113156.sqb (The operation completed successfully).
SQL Backup exit code: 141

Restoring database to destination server - Failed
This operation failed with errors.
Restoring CTSY2KV1 (database) from:
\\drGlendale\CTSY2KV1\SEED_CTSY2K_20091020113156.sqb
Thread 0 error:
Data decompression error: file may be corrupted
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 Backup exit code: 790
SQL error code: 3270

Creating backup job - Pending
Operation pending.

Create restore job - Pending
Operation pending.

Refresh server information - Pending
Operation pending.
vad2319
0

Comments

2 comments

Sort by
  • Eddie D
    Thank you for your post into the forum.

    I believe that you may have already contacted Red Gate Product Support Team and opened a support ticket, call reference F0027852.

    I have just replied to you.

    Many Thanks
    Eddie
    Eddie D
    0
  • vad2319
    You did send me an email. Thanks Eddie.
    vad2319
    0

Add comment

Please sign in to leave a comment.