Error: not enough space even though plenty is available
That said, all of the databases with a raw size over about 10GB are failing with a "There is not enough space on the disk" error message. The databases under 10GB raw size are being backed up just fine. Does SQL Backup maybe stage the backup to disk on a drive other than the destination drive, and that's what would be causing this error?
Here's a sample error message from one of the databases that fails.
8/19/2009 4:54:40 AM: BACKUP DATABASE [MyDatabaseName] TO VIRTUAL_DEVICE = 'SQLBACKUP_AB2E77A3-BB08-448D-BAA9-2D7B836B195C' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MyDatabaseName), 8/19/2009 4:54:39 AM', DESCRIPTION = N'Backup on 8/19/2009 4:54:39 AM Server: BENGAL\DEV05 Database: MyDatabaseName', FORMAT 8/19/2009 5:00:39 AM: Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 8/19/2009 5:00:39 AM: Warning 210: Thread 0 warning: Warning 210: Error writing to backup file: K:\Databases\DEV05\FULL_DEV05_MyDatabaseName_20090819_045439.sqb Warning: System error 112 (There is not enough space on the disk) 8/19/2009 5:00:39 AM: SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_AB2E77A3-BB08-448D-BAA9-2D7B836B195C:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). SQL error 3202: SQL error 3202: Write on "SQLBACKUP_AB2E77A3-BB08-448D-BAA9-2D7B836B195C" failed: 1117(The request could not be performed because of an I/O device error.)
Thanks for your help!