odd behaviour with network CopyTo function

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

odd behaviour with network CopyTo function

Postby john galloway » Thu Jan 03, 2013 1:58 pm

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\\differentialthere is a quota on the share folder, of 100Gb, of which 2.18Gb is used.

i'm stumped.

John
john galloway
 
Posts: 5
Joined: Thu Jan 03, 2013 1:47 pm

Postby petey » Fri Jan 04, 2013 10:41 am

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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby john galloway » Fri Jan 04, 2013 3:23 pm

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
john galloway
 
Posts: 5
Joined: Thu Jan 03, 2013 1:47 pm

Postby petey » Fri Jan 04, 2013 5:03 pm

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

Code: Select all
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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby john galloway » Fri Jan 04, 2013 6:04 pm

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
john galloway
 
Posts: 5
Joined: Thu Jan 03, 2013 1:47 pm

Postby petey » Mon Jan 07, 2013 1:22 am

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

Code: Select all
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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby john galloway » Mon Jan 07, 2013 9:46 am

Hi Pete

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

John
john galloway
 
Posts: 5
Joined: Thu Jan 03, 2013 1:47 pm

Postby john galloway » Mon Jan 07, 2013 3:35 pm

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
john galloway
 
Posts: 5
Joined: Thu Jan 03, 2013 1:47 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 2 guests