Warning 141: COPYTO error: Unable to copy
vad2319
Posts: 40
Hi,
I keep getting this error when I try to set up log shipping. when I used the trial version couple of months back I did not get this error, but after purchasing it, I cannot setup logshipping. Please advise. Thanks!
Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed with warnings.
Backing up CTSY2K (full database) to:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20080228134046.sqb
Database size : 60.382 GB
Compressed data size: 4.595 GB
Compression rate : 92.39%
Processed 2919744 pages for database 'CTSY2K', file 'CTSY2K_dat' on file 1.
Processed 103 pages for database 'CTSY2K', file 'CTSY2K_log' on file 1.
BACKUP DATABASE successfully processed 2919847 pages in 216.562 seconds (110.450 MB/sec).
Warning 141: COPYTO error: Unable to copy C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20080228134046.sqb to \\drSQLServer\redgate\SEED_CTSY2K_20080228134046.sqb (The operation completed successfully).
SQL Backup exit code: 141
Restoring database to destination server - Failed
This operation failed with errors.
Restoring CTSY2K_6 (database) from:
\\drSQLServer\redgate\SEED_CTSY2K_20080228134046.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_A34A9B3B-D4E3-495B-B052-55B20D290101' is incorrectly formed. SQL Server cannot process this media family.
SQL Backup exit code: 790
SQL error code: 3241
Creating backup job - Pending
Operation pending.
Create restore job - Pending
Operation pending.
Refresh server information - Pending
Operation pending.
I keep getting this error when I try to set up log shipping. when I used the trial version couple of months back I did not get this error, but after purchasing it, I cannot setup logshipping. Please advise. Thanks!
Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed with warnings.
Backing up CTSY2K (full database) to:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20080228134046.sqb
Database size : 60.382 GB
Compressed data size: 4.595 GB
Compression rate : 92.39%
Processed 2919744 pages for database 'CTSY2K', file 'CTSY2K_dat' on file 1.
Processed 103 pages for database 'CTSY2K', file 'CTSY2K_log' on file 1.
BACKUP DATABASE successfully processed 2919847 pages in 216.562 seconds (110.450 MB/sec).
Warning 141: COPYTO error: Unable to copy C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20080228134046.sqb to \\drSQLServer\redgate\SEED_CTSY2K_20080228134046.sqb (The operation completed successfully).
SQL Backup exit code: 141
Restoring database to destination server - Failed
This operation failed with errors.
Restoring CTSY2K_6 (database) from:
\\drSQLServer\redgate\SEED_CTSY2K_20080228134046.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_A34A9B3B-D4E3-495B-B052-55B20D290101' is incorrectly formed. SQL Server cannot process this media family.
SQL Backup exit code: 790
SQL error code: 3241
Creating backup job - Pending
Operation pending.
Create restore job - Pending
Operation pending.
Refresh server information - Pending
Operation pending.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8