SQLBackup 6 Qustion backup error on large database 1.9 TB
Yasir
Posts: 4
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.
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
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: 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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.)
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
The last full backup was failed at 480 GB and it should be 1.8 TB. The file system format is NTFS.
- turning off NTFS compression
- defragmenting the disk
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8