COPYTO to network share fails from time to time
knockout
Posts: 8
Hi,
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:
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 5.3.0.178 -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).
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8