AhsayCBS (DIY)MS SQL ODBC Backup Fails: Not Enough Disk Space in Temp Directory
April 16, 2025
Product Version
AhsayOBM: 7 and above
Operating System
Windows
Symptom
When performing a MS SQL Database Backup (ODBC Mode), the following warning message is received in the backup report:
| No. | Type | Timestamp | Log |
| * | info | YYYY/MM/DD hh:mm:ss | [Start] Backing up "SQL_hostname\MSDB\db_name" using "Transaction log" to "temp_path" |
| * | warn | YYYY/MM/DD hh:mm:ss | [Microsoft][ODBC SQL Server Driver][SQL Server] A nonrecoverable I/O error occurred on file "temp_path\backupset_id\...\db_name\db_name.bak.YYYY- MM-DD-hh-mm-ss.ADD:"112 (There is not enough space on the disk.). |
Cause
The message suggests that there is insufficient free space in the temporary directory for storing backup files.
Resolution
To resolve the issue, ensure that there is sufficient free space available in the temporary directory for storing backup files. Alternatively, configure the temporary directory to another volume (accessible by the MS SQL service) with sufficient disk space.
