Red Gate forums :: View topic - odd behaviour with network CopyTo function
Return to www.red-gate.com RSS Feed Available

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

odd behaviour with network CopyTo function

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
john galloway



Joined: 03 Jan 2013
Posts: 5

PostPosted: Thu Jan 03, 2013 1:58 pm    Post subject: odd behaviour with network CopyTo function Reply with quote

Hi all.
anyone come across this before?
running SQL Backup 7.2.1.4 on a Windows 2008 R2 server.
doing a differential backup, every hour.
part of the process copies the backups to a network share, on a Buffalo Terastation also running W2008R2.
at 0900 (and earlier) it works, saying:
03/01/2013 09:00:01: Copied H:\SQLBackup\Differential\DIFF_(local)_model_20130103_090000.sqb to \\crdbackup2\crdecms3\differential\DIFF_(local)_model_20130103_090000.sqb

at 1000, it gives a warning saying it can't create a folder:
Warning 141: COPYTO error: Unable to copy H:\SQLBackup\Differential\DIFF_(local)_model_20130103_100000.sqb to \\crdbackup2\crdecms3\differential\DIFF_(local)_model_20130103_100000.sqb ().
03/01/2013 10:05:31: COPYTO error: Failed to create folder: \\crdbackup2\crdecms3\differential
there is a quota on the share folder, of 100Gb, of which 2.18Gb is used.

i'm stumped.

John
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Jan 04, 2013 10:41 am    Post subject: Reply with quote

It looks like SQL Backup could not find the folder, and attempted to create the folder. Note that it attempted to do this 10 times, at 30 second intervals. Is it possible that the network share was unreachable during that time?
_________________
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
john galloway



Joined: 03 Jan 2013
Posts: 5

PostPosted: Fri Jan 04, 2013 3:23 pm    Post subject: Reply with quote

Hi Pete
no, the backup share was there all the time.
what's really confusing me is that it WAS working and then stopped.
and, in fact, the copy has continued not working every hour since.
pretty sure it's some permissions issue, but machine a (where the share is) will not recognise local accounts on machine b (where the database and backup is) despite them being on the same domain.
John
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Jan 04, 2013 5:03 pm    Post subject: Reply with quote

Do you get a similar error if you try to back up directly to the network share e.g.

Code:
EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [\\crdbackup2\crdecms3\differential\<AUTO>] WITH DIFFERENTIAL, DISKRETRYCOUNT = 0"'

_________________
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
john galloway



Joined: 03 Jan 2013
Posts: 5

PostPosted: Fri Jan 04, 2013 6:04 pm    Post subject: Reply with quote

Hi Pete

get
Backing up model (differential database) to:
\\crdbackup2\crdecms3\differential\DIFF_(local)_model_20130104_170256.sqb

Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
Warning 200: Thread 0 warning:
04/01/2013 17:02:56: Warning 480: Failed to create output folder: \\crdbackup2\crdecms3\differential\.
Warning 480: Failed to create output folder: \\crdbackup2\crdecms3\differential\.

SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_CC61755A-3E31-442E-8050-7015028E1BE3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_CC61755A-3E31-442E-8050-7015028E1BE3" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)

SQL Backup exit code: 790
SQL error code: 3202

John
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Mon Jan 07, 2013 1:22 am    Post subject: Reply with quote

What is the result that's returned if you run the following from SSMS:

Code:
EXEC master..sqbutility 999, 'RWE', '\\crdbackup2\crdecms3\differential\'

This command tests for read, write and deletion rights on the network share.
_________________
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
john galloway



Joined: 03 Jan 2013
Posts: 5

PostPosted: Mon Jan 07, 2013 9:46 am    Post subject: Reply with quote

Hi Pete

result
<SQBUTILITYRESULT>:0:Folder does not exist : \\crdbackup2\crdecms3\differential
although the folder does exist and can be seen through network share

John
Back to top
View user's profile Send private message
john galloway



Joined: 03 Jan 2013
Posts: 5

PostPosted: Mon Jan 07, 2013 3:35 pm    Post subject: Reply with quote

Hi Pete
have restarted SQl Backup service using account which occurs on both database server and backup filestore server (which wasn't the case before) and the network copy function now works as I want it to.
**!!$$%% permissions!
thanks for your time.
John
Back to top
View user's profile Send private message
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