Competition: What’s your favorite Redgate tool? Enter now.

Warning 141: COPYTO error: Unable to copy

vad2319vad2319 Posts: 40
edited February 29, 2008 8:03PM in SQL Backup Previous Versions
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.

Comments

  • peteypetey Posts: 2,358 New member
    The COPYTO process requires that the SQL Backup Agent service startup user has read/write rights to the network share it is copying to i.e. \\drSQLServer\redgate.
    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.