The backups on ONE of my servers failed last night. It happens to be on the server that has two enclosures on it. I'm fairly crertain I know what the problem is already, I'm just curious about one thing.
I've got two enclosures on this box; SATA (yuck) and HP. The SATA promise enclosure is faulty right now, taking IT forever and a day to backup, and we had already intended to bounce it this weekend.
the problem has been in affect for a couple weeks, maybe, and my backups have never failed..... until now.
I'm just trying to confirm the source of the failure is in fact the enclosure. The backup target directory is 'G\MSSQL\Backup\*.*', and this is on the sata.
I can see the target drive, where the BAK files are written. But maybe SQL can't - these are the errors I received from the backup failure, in the order of receipt:
BackupIoRequest::ReportIoError: write failure on backup device 'G:\MSSQL\BACKUP\dbname\dbname_20091224.BAK'. Operating system error 2(The system cannot find the file specified.).
BACKUP failed to complete the command BACKUP DATABASE dbname. Check the backup application log for detailed messages.
The operating system returned the error '2(The system cannot find the file specified.)' while attempting 'SetEndOfFile' on 'G:\MSSQL\BACKUP\dbname\dbname_20091224.BAK'.
The operating system returned the error '2(The system cannot find the file specified.)' while attempting 'FlushFileBuffers' on 'G:\MSSQL\BACKUP\dbname\dbname_20091224.BAK'.
SQL Server Scheduled Job 'User Database Maintenance' (0xEAA8B9AE5C368446BAD522BE8692D7DE) - Status: Failed - Invoked on: 2009-12-24 22:00:01 - Message: The job failed. The Job was invoked by Schedule 18 (User Database Maintenance Schedule). The last step to run was step 3 (Send Notification - Failure).
I just now tried it manually (separate from the agent job). It failed immediately, with this:
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'G:\MSSQL\BACKUP\dbname\dbname_20091225.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
so i am thinking maybe the enclosure issue is just escalating... but, here's the query - i saved a test.txt file to the root of G, no problems. I just tried to save the test.txt file to the backup target directories -- these are just the 'dbname' subdirectories within G:\MSSQL\Backup -- it failed w/this:
Path does not exist.
Verify the correct path was given.
Anybody seen this before?