When trying to expand the physical file, modify file encountered an operating system error of 112 (insufficient disk space ).
Many of my friends may encounter an operating system error 112 (insufficient disk space) in Modify file when they try to expand physical files during "data restoration ). The space allocation of the file 'bbs _ log' cannot be adjusted. The Restore database operation is terminated abnormally. "The following describes how to solve the problem:
This is usually because of the file system. If your computer is a FAT32 file system, this problem may occur when you restore a large database.
The solution is to convert the FAT32 File System to NTFS
I have tried it many times. As long as I convert fat32l to NTFS, I can convert FAT32 to NTFS:
No formatting is required. Run cmd: Enter the convert D:/Fs: NTFS command.
In this way, the file system can be re-FAT32 to NTFS! In addition, the files on the original disk will not be lost.
Note(Where, D is the drive letter. This is changed based on the disk where your database is located, and the storage space for the database should be large enough .. At least 2 GB. This problem occurs generally because the log file is too large, so an error message is prompted .)
The reason is: FAT32 does not support a single file larger than 2 GB .. The following table lists the file sizes supported by various partition formats.
NTFS (Windows): supports up to 2 TB of partitions and 2 TB of files.
Fat16 (Windows): supports a maximum partition of 2 GB and a maximum file of 2 GB.
FAT32 (Windows): supports a maximum partition of 128 GB and a maximum file of 4 GB.
HPFs (OS/2): supports a maximum of 2 TB partitions and a maximum of 2 GB files
Ext2 and ext3 (Linux): supports a maximum of 4 TB partitions and a maximum of 2 GB files.
JFS (Aix): supports a maximum partition of 4 P (block size = 4 K) and a maximum of 4 P
XFS (IRIX): A 64-bit file system that supports 9e (63 power of 2) partitioning.
After a successful restoration, the data file is usually not very large, but the log file has several GB. How to contract the database? Run the following command:
DBCC shrinkdatabase (enter the database name here, 10)
Example: DBCC shrinkdatabase (vegoo, 10)
# Database Technology