OS
WindowsSoftware
7.9 and higherError message
[Microsoft][ODBC SQL Server Driver][SQL Server]Write on "F:\Backup Temp\SQL\1234944360553\[..].bak.2021-10-07-00-00-00-000.ADD" failed: 112(There is not enough space on the disk.)[Microsoft][ODBC SQL Server Driver][SQL Server]Unrecoverable I/O error for file "C:\Users\administrator\temp\1580152741183\[...].bak.2022-02-12-19-00-00-000.ADD": 112(There is not enough disk space available.) SQLSTATE = 42000
Cause
At the moment the export of a database starts the uncompressed space required for the export is reserved.When there is insufficient free space in the temporary directory for this, the above error will occur for that database.
The MSSQL database works in the following manner:
- The backup manager will request a copy of the databases using a SQL-Query via sqldump.
- The MSSQL server will 'freeze' the status of the databases, but will still function by storing all transactions into logfiles.
- The database will be copied by the SQL server into the temporary folder.
- When the copying of the databases is finished, the database becomes writable again and the transaction logs are processed.
- The OBM will read out the database and compares it with a previous backup, and (if there are differences) will create a incremental of differential file.
- The full database or the differences will be uploaded to the backup server.
Solution
We recommend you to choose a temporary folder on a disk which is not used for windows or the SQL server, to prevent problems.- Stop all running SQL backup tasks.
- Remove the content of the temporarily directory of the SQL set.
- Choose a different folder on a disk which has at least the free space available to contain 1.5 times the size of the database(s)
- Open the software.
- Go to the Backup Sets.
- Choose the SQL backupset
- Click on Show advanced settings.
- Go to the Others tab.
- Select a different temporary folder
- Click Save.