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

log shipping error on restore(SQL Backup version

vad2319vad2319 Posts: 40
edited October 22, 2009 1:02PM in SQL Backup Previous Versions

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?


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:
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.


Sign In or Register to comment.