'The drive cannot find the sector requested'...

SQL_ME_RICHSQL_ME_RICH Posts: 112
edited July 19, 2012 2:25AM in SQL Backup Previous Versions
I have the following...

SQL Backup log file 7.1.0.72
SQL Backup 7.1.0.214

I realize this probably isn't a Red Gate specific error (because I have seen this same error listed when attempting to do a native full backup as well), but can you shed any light on what would be causing my backup jobs to faile and list this error as the reason? It is happening with all of my database now, where I have mostly success before. This is a fairly older server (HP DL380 G5 with Non-Hyperthreaded CPU's), but the fact that I cannot get a successful Full backup of any of my databases is discouraging. Here is the error and warnings:

-SQL "BACKUP DATABASE [adt_trak_restore] TO DISK = 'G:\Backups\<AUTO>.sqb'
WITH CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 7, VERIFY "

ERRORS AND WARNINGS


7/17/2012 10:10:01 PM: Backing up adt_trak_restore (full database) to:
7/17/2012 10:10:01 PM: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb

7/17/2012 10:10:02 PM: BACKUP DATABASE [adt_trak_restore] TO VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E', VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E01', VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D
99E10E02', VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E03', VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E04', VIRTUAL_DEVICE = 'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E05', VIRTUAL_DEVICE =
'SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (adt_trak_restore), 7/17/2012 10:10:01 PM', DESCRIPTION = N'Backup on 7/17/2012 10:10:01 PM Server: PRO-DBSERVER1A
Database: adt_trak_restore', FORMAT, CHECKSUM

7/17/2012 10:22:23 PM: 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.)
7/17/2012 10:22:23 PM: Warning 210: Thread 0 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: 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.)
7/17/2012 10:22:23 PM: Warning 210: Thread 1 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: 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.)
7/17/2012 10:22:23 PM: Warning 210: Thread 2 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: Thread 3 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
7/17/2012 10:22:23 PM: Warning 210: Thread 3 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: Thread 4 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
7/17/2012 10:22:23 PM: Warning 210: Thread 4 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: Thread 5 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
7/17/2012 10:22:23 PM: Warning 210: Thread 5 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: Thread 6 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
7/17/2012 10:22:23 PM: Warning 210: Thread 6 warning:
WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb at position: 1024
7/17/2012 10:10:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:11:13 PM: Re-attempt: 1
7/17/2012 10:11:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:12:23 PM: Re-attempt: 2
7/17/2012 10:13:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:13:33 PM: Re-attempt: 3
7/17/2012 10:14:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:14:43 PM: Re-attempt: 4
7/17/2012 10:15:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:15:53 PM: Re-attempt: 5
7/17/2012 10:16:33 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:17:03 PM: Re-attempt: 6
7/17/2012 10:17:43 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:18:13 PM: Re-attempt: 7
7/17/2012 10:18:53 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:19:23 PM: Re-attempt: 8
7/17/2012 10:20:03 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:20:33 PM: Re-attempt: 9
7/17/2012 10:21:13 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:21:43 PM: Re-attempt: 10
7/17/2012 10:22:23 PM: WriteFile failed for file: G:\Backups\FULL_(local)_adt_trak_restore_20120717_221001.sqb (27: The drive cannot find the sector requested.)
7/17/2012 10:22:23 PM:
7/17/2012 10:22:23 PM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
7/17/2012 10:22:23 PM: SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E02:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
7/17/2012 10:22:23 PM: SQL error 3202: SQL error 3202: Write on "SQLBACKUP_CC1762FE-6788-4654-A679-BB164D99E10E" failed: 1117(The request could not be performed because of an I/O device error.)



Any and all help would be really appreciated. This is a PROD system that I not hae not been able to get backed up since the 12 of the month.

Thank you,
SQL_ME_RICH

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    Hi SQL_ME_RICH

    I suspect that you may have a problem with the actual disk drive using the drive letter G:\.

    I recommend that you attempt to backup to another disk and see if this action resolves the error.

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

    I suspect that you may have a problem with the actual disk drive using the drive letter G:\.

    I recommend that you attempt to backup to another disk and see if this action resolves the error.

    Many Thanks
    Eddie

    Hello Eddie - Thank you for the quick response!

    The drive in question is a SAN disk, and I probably should have pointed out that it's a NetAPP SAN and the disks have been checked, and have no errors. I have tried multiple LUN's.

    This is running SQL Server 2005 Standard Edition 64-bit, which is troublesome enough, but should still work. I am not sure what has caused this to start to fail, and have been investigating everything from the WebApp front end (because of recent deployments all the moving pieces and such) to trying different LUN's to get the thing to backup.

    Any other ideas?
  • I am sure that you have already tried this but.

    Can you write anything to that drive?
    Can you write anything to that drive using the Windows account that SQLBackup is using?
    Can you do a log backup or a differential backup rather than a full?
    Can you run DBCC Checkdb with PHYSICAL_ONLY on the database in question?

    Chris
    English DBA living in CANADA
  • I am sure that you have already tried this but.

    Can you write anything to that drive?
    Can you write anything to that drive using the Windows account that SQLBackup is using?
    Can you do a log backup or a differential backup rather than a full?
    Can you run DBCC Checkdb with PHYSICAL_ONLY on the database in question?

    Chris

    Hey Chris - no, these are all good questions, and yes to all but the last - I cannot get jobs to execute on this server, not matter what window of opportunity I use. I had to stop all maintenance on the server because of the length of time the jobs were running (even with just the PHYSICAL_ONLY checks on DBCC).

    It's been pretty frustrating, and I am getting paranoid about not having any backups of this system (we had another one crash on Monday this week, and had it not been for the backup sets for those databases that I had been keeping, heads would have rolled).

    Any other thoughts?
  • If you haven't tried the DBCC CHECKDB then it could be the CHECKSUM. It could also be the verify. If your DB is corrupt good luck. You will need Paul Randal's help http://sqlskills.com/blogs/paul/.

    hopefully you have the last full backup at hand and if you could run a differential without checksum and verify and you had somewhere else to restore them to you could run the DBCC CHECKDB.

    Chris
    English DBA living in CANADA
  • If you haven't tried the DBCC CHECKDB then it could be the CHECKSUM. It could also be the verify. If your DB is corrupt good luck. You will need Paul Randal's help http://sqlskills.com/blogs/paul/.

    hopefully you have the last full backup at hand and if you could run a differential without checksum and verify and you had somewhere else to restore them to you could run the DBCC CHECKDB.

    Chris

    I'm hoping and praying that I DO NOT have corruption! I have had to go against the grain with every fiber of my being to compromise certain things for this particular database server (because if customer's are complaining about slowness in the environment, then what's the point...).

    If it is corrupt, the only silver lining will be the massive push that I have been on for the past month to migrate it over to another server with twice as much RAM (32gb) and the Enterprise Edition of 2005 SQL Server (but the problem has been that they do not want to take the outage to get it done in the simpliest of fashions - just a straight copy of the .mdf and .ldf to get it over to the new box). I guess when they wind up taking an unplanned outage, they might finally move.

    Thanks again Chris - I am going to try one more LUN tonight, then see if I cannot run you idea tomorrow as needed.
  • Here's a tip if you didn't have the problems that you have. I saw this technique at PASS a few years ago.

    They set up their new server with all the jobs etc of the old server. They made sure that it worked fine. They then took a full backup and restored it with norecovery. They then took differentials and restored the last with norecovery and finished it off by running a log backup and restoring with recovery. They were doing a bigger job than you by upgrading versions and moving to a cluster so that would have made your task easier even if you upgraded the SQL build. But you have no backups so that would not work.

    What I determined from that was to have the system databases on a different drive and LUN. If we ever had to do that I would shutdown SQL on the old server, unpresent the drive from the old server, present it to the new server and attach the database files. If it was going from the same build of SQL then nothing more would be needed other than maybe point clients at the new server.

    Might even be able to try this in the near future.

    Chris
    English DBA living in CANADA
  • peteypetey Posts: 2,358 New member
    Does something like this work?
    EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = &#91;g:\backups\&lt;AUTO&gt;.sqb&#93; WITH CHECKSUM, COMPRESSION = 4, VERIFY, MAXDATABLOCK = 65536"'
    
    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.