A nonrecoverable I/O error occurred on file “XXXX” 112(failed to retrieve text for this error. Reason: 15105

Error

[Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file “C:\cybersecure-spool\1312939129295\SQL-SERVE\(local)\DB\DATABASE.bak.2012-01-04-21-00-00-000.ADD:” 112(failed to retrieve text for this error. Reason: 15105

Cause

  1. Generally this means there’s not enough space on the disk to spool the SQL backup. Here’s how to find/change the spooling location.
  2. It can also be from the volume on which the spooling location resides is heavily fragmented.

Resolution

  1. Free up some space
  2. Run a defragmentation tool and assess the fragmentation level on all volumes, defrag if fragmentation level is > 15%