Red Gate forums :: View topic - 'The drive cannot find the sector requested'...
Return to www.red-gate.com RSS Feed Available

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

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

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Wed Jul 18, 2012 6:31 pm    Post subject: 'The drive cannot find the sector requested'... Reply with quote

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



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

PostPosted: Wed Jul 18, 2012 7:54 pm    Post subject: Reply with quote

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
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
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Wed Jul 18, 2012 8:06 pm    Post subject: Re: Reply with quote

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



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Wed Jul 18, 2012 9:22 pm    Post subject: Reply with quote

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



Joined: 08 May 2012
Posts: 64

PostPosted: Wed Jul 18, 2012 10:18 pm    Post subject: Re: Reply with quote

ChrisAVWood wrote:
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?
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Wed Jul 18, 2012 10:25 pm    Post subject: Reply with quote

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



Joined: 08 May 2012
Posts: 64

PostPosted: Wed Jul 18, 2012 10:45 pm    Post subject: Re: Reply with quote

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



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Wed Jul 18, 2012 10:56 pm    Post subject: Reply with quote

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



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Thu Jul 19, 2012 7:25 am    Post subject: Reply with quote

Does something like this work?

Code:
EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [g:\backups\<AUTO>.sqb] 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 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