COPYTO to network share fails from time to time

Forum for users of Red Gate SQL Backup tool

COPYTO to network share fails from time to time

Postby knockout » Mon Nov 19, 2012 12:15 am

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:

Code: Select all
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).
knockout
 
Posts: 5
Joined: Thu Jan 17, 2008 5:44 am

Postby petey » Thu Jan 31, 2013 1:53 pm

It may be due to intermittent network outages on your server box.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby petey » Thu Jan 31, 2013 2:20 pm

It may be due to intermittent network outages on your server box.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests