Write on 'Directory_Path\Backup_ID\(local)\*.bak.ADD' failed, status = 112 (MS SQL database backup)

ServosityPro: All
OS: Windows

When performing a MS SQL database backup, the following error message is received in the backup report:

Backup Logs  No.  Type  Timestamp  Backup Logs 1 Info YYYY/MM/DD hh:mm Start [ Windows platform (Test), ServosityPro 5.x.x.x ] 2 Info YYYY/MM/DD hh:mm Start running pre-commands 3 ... ... ... *  Error  YYYY/MM/DD hh:mm [[Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'Directory_Path\Backup_ID\ (local)\*.bak.YYYY-MM-DD-hh-mm-ss.ADD' failed, status = 112. See the SQL Server error log for more details.

The message suggests that the disk space on the MS SQL server has run out.

This error can also occurs if the following conditions are true:

1. The temporary directory specified for the MS SQL database backup set is on a File Allocation Table (FAT32) volume
2. The database file to be backed up exceeded 4GB

Since the maximum possible size for a file on a FAT32 volume is 4GB minus 1 bytes, the error is flagged due to FAT32's limitation.

In order to perform a MS SQL database backup, it is required for the corresponding machine to have sufficient free space for the spooling of the database file. To resolve the issue, please free up some disk space on the local drive.

Alternatively, you can also configure the temporary spooling of the database file to a network path.

In the cases where the temporary directory is on a FAT32 volume, and the database file to be backed up exceeded 4GB, please convert the FAT32 volume to NTFS with the following instructions:

1. Click Start, Programs, and then Command Prompt
2. At the command prompt, type CONVERT [driveletter]: /FS:NTFS
3. Convert.exe will attempt to convert the partition to NTFS

Notes:
Once you convert a drive or partition to NTFS, you cannot simply convert it back to FAT or FAT32. You will need to reformat the drive or partition which will erase all data, including programs and personal files, on the partition.