- Product Version:
- Problem Description:
- Cause:
- Resolution:
- Also See:
ServosityPro: All
OS: Windows
OS: Windows
When performing a MS SQL database backup, the following error message is received in the backup report:
|
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.
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.
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.