Red Gate forums :: View topic - SQLBackup 6 Qustion backup error on large database 1.9 TB
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

SQLBackup 6 Qustion backup error on large database 1.9 TB

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Yasir



Joined: 09 Apr 2013
Posts: 3

PostPosted: Tue Apr 09, 2013 10:46 am    Post subject: SQLBackup 6 Qustion backup error on large database 1.9 TB Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Tue Apr 09, 2013 11:43 am    Post subject: Reply with quote

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:
Quote:

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
Back to top
View user's profile Send private message Send e-mail
Yasir



Joined: 09 Apr 2013
Posts: 3

PostPosted: Wed Apr 10, 2013 3:17 pm    Post subject: Reply with quote

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.)
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Sat Apr 13, 2013 2:13 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Yasir



Joined: 09 Apr 2013
Posts: 3

PostPosted: Mon Apr 15, 2013 12:05 pm    Post subject: Reply with quote

Thanks Peter,
The last full backup was failed at 480 GB and it should be 1.8 TB. The file system format is NTFS.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Wed Apr 17, 2013 1:43 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group