| Author |
Message |
knockout
Joined: 17 Jan 2008
Posts: 5
|
 Posted: Mon Nov 19, 2012 12:15 am Post subject: COPYTO to network share fails from time to time |
 |
|
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 |
|
 |
petey
Joined: 24 Apr 2005
Posts: 2216
|
| Posted: Thu Jan 31, 2013 1:53 pm Post subject: |
|
|
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 |
|
|
petey
Joined: 24 Apr 2005
Posts: 2216
|
| Posted: Thu Jan 31, 2013 2:20 pm Post subject: |
|
|
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 |
|
|
|
|
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
