When performing a MS SQL 2000, 2005 or 2008 database backup, the following error message is received in the backup report:
[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 ran out.
In order to perform a MS SQL database backup, you need to have sufficient free space on the disk to temporary store .bak files. To resolve the issue, please free up some disk space on the local drive configured as temporary directory.
You can also configure the temporary directory to another (network) drive.
In the cases where the temporary directory is on a FAT32 volume, the maximum possible size for a file on a FAT32 volume is 4GB minus 1 bytes . If you want to backup database files which exceed 4GB, please convert the FAT32 volume to NTFS.
For more information about NTFS conversion:
http://support.microsoft.com/kb/325334
or
