MS SQL ODBC Backup Fails: Not Enough Disk Space in Temp Directory
April 16, 2025
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.). |