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

COPYTO to network share fails from time to time

knockoutknockout Posts: 8
edited January 31, 2013 8:20AM in SQL Backup Previous Versions

I am using RedGate SQL Backup Pro v5.3 on SQL Server 2005 running on a Windows Server 2008 R2 x64 server with 96GB of RAM.

I am seeing COPYTO failures (warning 141) every now and then. I searched the forums and tried setting MAXDATABLOCK and MAXTRANSFERSIZE parameters to the lowest possible setting, but that did not seem to help fix it. I have verified that it is not a permissions issue because the COPYTO goes through sometimes without failing.

We have the same version of SQL Backup Pro running on other Windows Server 2003 servers where we do not see any such errors.

Here are the contents of the log file:
SQL Backup log file

-SQL "BACKUP LOG [DB6] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', INIT, COMPRESSION = 2, MAXDATABLOCK = 65536, MAXTRANSFERSIZE = 65536, MAILTO_ONERROR = 'DGG_DBA@corp.fanbox.com', COPYTO = '\\itbackup.colo.sms.ac\E$\Backup\SQL03\DB6' "

-----------------------------  ERRORS AND WARNINGS -----------------------------

11/18/2012 2:41:00 PM: Warning 141: COPYTO error: Unable to copy Y:\Backup\SQL03\DB6\DB6_LOG_20121118_143801.sqb to \\itbackup.colo.sms.ac\E$\Backup\SQL03\DB6\DB6_LOG_20121118_143801.sqb (The operation completed successfully).

-----------------------  PROCESSES COMPLETED SUCCESSFULLY   --------------------

11/18/2012 2:38:00 PM: Backing up DB6 (transaction log) to: 
11/18/2012 2:38:00 PM:   Y:\Backup\SQL03\DB6\DB6_LOG_20121118_143800.sqb

11/18/2012 2:38:01 PM: BACKUP LOG [DB6]  TO VIRTUAL_DEVICE = 'SQLBACKUP_9564169D-6D3B-4535-AC49-E0211C378C2A' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (DB6), 11/18/2012 2:38:01 PM', DESCRIPTION = N'Backup on 11/18/2012 2:38:01 PM  Server: SQL03  Database: DB6'

11/18/2012 2:40:37 PM: Backup data size    : 2.497 GB
11/18/2012 2:40:37 PM: Compressed data size: 908.147 MB
11/18/2012 2:40:37 PM: Compression rate    : 64.49%

Processed 326527 pages for database 'DB6', file 'DB6_Log' on file 1.
BACKUP LOG successfully processed 326527 pages in 154.645 seconds (17.297 MB/sec).


Sign In or Register to comment.