odd behaviour with network CopyTo function

john gallowayjohn galloway Posts: 6
edited January 7, 2013 9:35AM in SQL Backup Previous Versions
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

Comments

  • peteypetey Posts: 2,358 New member
    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 8
  • 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
  • peteypetey Posts: 2,358 New member
    Do you get a similar error if you try to back up directly to the network share e.g.
    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 8
  • 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
  • peteypetey Posts: 2,358 New member
    What is the result that's returned if you run the following from SSMS:
    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 8
  • Hi Pete

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

    John
  • 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
Sign In or Register to comment.