Sqlserver error "when trying to expand the physical file, modify file encountered an operating system error of 112 (insufficient disk space .)." Processing

Source: Internet
Author: User
An error is reported during normal restoration:

Microsoft SQL-DMO (ODBC sqlstate: 42000)
---------------------------
When trying to expand the physical file, modify file encountered an operating system error of 112 (insufficient disk space .).
One or more files cannot be created. Use the with move option to identify a valid location.
The Restore database operation is terminated abnormally.
However, the hard disk space is sufficient!

Solution:

If the disk space of the restored database file is insufficient
You can use the following statement to query the number of files in the restored database, and the size of these files. After restoration, the files will be placed on that disk.
Restore filelistonly from disk = 'C: \ backup file name. Bak'
If you want to put the data file on another disk with enough space, use the move option to change the location of the restored file.
Restore database name from disk = 'C: \ backup file name. Bak'
With move 'logical file name' to 'C: \ AA. MDF '-- the logical file name can be queried using restore filelistonly. c: \ AA. MDF is the location and file name after the logical file name is restored.
If you are sure that your disk space is sufficient, the partition format may be a problem. For FAT32/16 partition formats, they support a maximum file size of 4G/2G, you can convert the partition format to NTFS.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.