SQLBackup 6 Qustion backup error on large database 1.9 TB

Compresses, encrypts, secures and monitors SQL Server backups.

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

SQLBackup 6 Qustion backup error on large database 1.9 TB

Postby Yasir » Tue Apr 09, 2013 10:46 am

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.
Yasir
 
Posts: 3
Joined: Tue Apr 09, 2013 9:53 am

Postby eddie davis » Tue Apr 09, 2013 11:43 am

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
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby Yasir » Wed Apr 10, 2013 3:17 pm

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.)
Yasir
 
Posts: 3
Joined: Tue Apr 09, 2013 9:53 am

Postby petey » Sat Apr 13, 2013 2:13 pm

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

Postby Yasir » Mon Apr 15, 2013 12:05 pm

Thanks Peter,
The last full backup was failed at 480 GB and it should be 1.8 TB. The file system format is NTFS.
Yasir
 
Posts: 3
Joined: Tue Apr 09, 2013 9:53 am

Postby petey » Wed Apr 17, 2013 1:43 am

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


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 1 guest