SQLBackup 6 Qustion backup error on large database 1.9 TB

Yasir

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.

Eddie D

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

Yasir

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.)

petey

What was the size of the incomplete backup file, and what file system format was the disk using?

Thanks.

Yasir

Thanks Peter,
The last full backup was failed at 480 GB and it should be 1.8 TB. The file system format is NTFS.

petey

Googling turned up some possibilities:

- turning off NTFS compression
- defragmenting the disk