SQLBackup 6 Qustion backup error on large database 1.9 TB

YasirYasir Posts: 4
edited April 16, 2013 8:43PM in SQL Backup Previous Versions
We have RedGate SQLBackup 6.3.0.48 installed on our OLAP Server running SQL Server 2008 having SP3 and when we are taking a backup of database having size 1.9TB we receivied the following error

665: The requested operation could not be completed due to a file system limitation.

We are able to complete Full backups on different occasions but mostly it gets failed with mentioned reason.
Need to verify if there is any issue in RegGate end or we have to do something on our end.

Help required.

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi Yasir,
    Thank you for your forum post and sorry that you have encountered a problem.

    Can please reply and copy the contents of the SQL Backup Log file? Right click the entry in the Activity Hostory and select show log. Hopefully the log file will contain all exit codes from Windows, SQL and SQL Backup to help accurately identify the cause.

    I suspect this error:
    665: The requested operation could not be completed due to a file system limitation.
    Is from Windows or SQL. From the notes I have on the SQL Backup Exit Codes, Exit Code 665 is used to indicate that a beta version of SQL Backup has now expired.

    I found this Microsoft ARTICLE which may help you.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Thanks Eddie,

    Here is the log, please review




    SQL Backup log file 7.2.1.82

    -SQL "BACKUP DATABASE [***MY_DATABASE_NAME***] TO DISK = '\\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb' WITH NO_CHECKSUM, COMPRESSION = 0, THREADCOUNT = 3 "


    ERRORS AND WARNINGS


    4/9/2013 1:16:23 AM: Backing up ***MY_DATABASE_NAME*** (full database) to:
    4/9/2013 1:16:23 AM: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb

    4/9/2013 1:16:23 AM: BACKUP DATABASE [***MY_DATABASE_NAME***] TO VIRTUAL_DEVICE = 'SQLBACKUP_954A8C27-3EC8-4717-AA4F-0CE9CE20C0E2', VIRTUAL_DEVICE = 'SQLBACKUP_954A8C27-3EC8-4717-AA4F-0CE9CE20C0E201', VIRTUAL_DEVICE = 'SQLBACKUP_954A8C27-3EC8-4717-AA4F-0CE9CE20C0E202'
    WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (***MY_DATABASE_NAME***), 4/9/2013 1:16:23 AM', DESCRIPTION = N'Backup on 4/9/2013 1:16:23 AM Server: ***MY_SERVER_NAME*** Database: ***MY_DATABASE_NAME***', FORMAT

    4/9/2013 4:00:14 AM: Thread 0 error:
    Error 620: Error writing to backup file(s).
    Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
    4/9/2013 4:00:14 AM: Warning 210: Thread 0 warning:
    WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb at position: 378928104448
    4/9/2013 3:55:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:55:43 AM: Re-attempt: 1
    4/9/2013 3:55:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:13 AM: Re-attempt: 2
    4/9/2013 3:56:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:43 AM: Re-attempt: 3
    4/9/2013 3:56:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:13 AM: Re-attempt: 4
    4/9/2013 3:57:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:43 AM: Re-attempt: 5
    4/9/2013 3:57:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:14 AM: Re-attempt: 6
    4/9/2013 3:58:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:44 AM: Re-attempt: 7
    4/9/2013 3:58:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:14 AM: Re-attempt: 8
    4/9/2013 3:59:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:44 AM: Re-attempt: 9
    4/9/2013 3:59:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM: Re-attempt: 10
    4/9/2013 4:00:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM:
    4/9/2013 4:00:14 AM: Thread 1 error:
    Error 620: Error writing to backup file(s).
    Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
    4/9/2013 4:00:14 AM: Warning 210: Thread 1 warning:
    WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb at position: 378928104448
    4/9/2013 3:55:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:55:43 AM: Re-attempt: 1
    4/9/2013 3:55:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:13 AM: Re-attempt: 2
    4/9/2013 3:56:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:43 AM: Re-attempt: 3
    4/9/2013 3:56:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:13 AM: Re-attempt: 4
    4/9/2013 3:57:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:43 AM: Re-attempt: 5
    4/9/2013 3:57:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:14 AM: Re-attempt: 6
    4/9/2013 3:58:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:44 AM: Re-attempt: 7
    4/9/2013 3:58:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:14 AM: Re-attempt: 8
    4/9/2013 3:59:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:44 AM: Re-attempt: 9
    4/9/2013 3:59:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM: Re-attempt: 10
    4/9/2013 4:00:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM:
    4/9/2013 4:00:14 AM: Thread 2 error:
    Error 620: Error writing to backup file(s).
    Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
    4/9/2013 4:00:14 AM: Warning 210: Thread 2 warning:
    WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb at position: 378928104448
    4/9/2013 3:55:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:55:43 AM: Re-attempt: 1
    4/9/2013 3:55:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:13 AM: Re-attempt: 2
    4/9/2013 3:56:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:56:43 AM: Re-attempt: 3
    4/9/2013 3:56:43 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:13 AM: Re-attempt: 4
    4/9/2013 3:57:13 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:57:43 AM: Re-attempt: 5
    4/9/2013 3:57:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:14 AM: Re-attempt: 6
    4/9/2013 3:58:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:58:44 AM: Re-attempt: 7
    4/9/2013 3:58:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:14 AM: Re-attempt: 8
    4/9/2013 3:59:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 3:59:44 AM: Re-attempt: 9
    4/9/2013 3:59:44 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM: Re-attempt: 10
    4/9/2013 4:00:14 AM: WriteFile failed for file: \\***MY_BACKUP_PATH***\***MY_BACKUP_FOLDER***\***MY_SERVER_NAME***\***MY_SERVER_NAME***_***MY_DATABASE_NAME***_FULL_20130409_011623.sqb (665: The requested operation could not be completed due to a file system limitation)
    4/9/2013 4:00:14 AM:
    4/9/2013 4:00:14 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
    4/9/2013 4:00:14 AM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_954A8C27-3EC8-4717-AA4F-0CE9CE20C0E2:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
    4/9/2013 4:00:14 AM: SQL error 3202: SQL error 3202: Write on "SQLBACKUP_954A8C27-3EC8-4717-AA4F-0CE9CE20C0E2" failed: 1117(The request could not be performed because of an I/O device error.)
  • peteypetey Posts: 2,358 New member
    What was the size of the incomplete backup file, and what file system format was the disk using?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Thanks Peter,
    The last full backup was failed at 480 GB and it should be 1.8 TB. The file system format is NTFS.
  • peteypetey Posts: 2,358 New member
    Googling turned up some possibilities:

    - turning off NTFS compression
    - defragmenting the disk
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.