Red Gate forums :: View topic - COPYTO to network share fails from time to time
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

COPYTO to network share fails from time to time

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
knockout



Joined: 17 Jan 2008
Posts: 5

PostPosted: Mon Nov 19, 2012 12:15 am    Post subject: COPYTO to network share fails from time to time Reply with quote

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:

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).
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Thu Jan 31, 2013 1:53 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Thu Jan 31, 2013 2:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group