Today encountered this problem, the Internet to find the following solutions:
1. Check your disk space is sufficient, if there is no disk space left, then clean the disk, make room
2. Check your disk partition format
If it is FAT16, then the maximum data file can be 2G
If it is FAT32, then the maximum data file can be 4G
Do not have this restriction if you change to an NTFS partition
3. Check to see if you limit the size of the database file
Enterprise Manager--right key to your database--attributes--File growth restrictions--if there is a limit, remove the limit
4. Check your SQL version and, if you use MSDE, limit the data file to a maximum of 2G
5. You can also add new data files to the primary group to solve the problem.
ALTER DATABASE name add file (name= logical filename, filename= ' c:/actual filename. ndf ')
After inspection is the 3rd file limit the size of the reason, landing into the server to check his database situation, the limit is 20M, now has been allocated 19M, the automatic growth of the file is also on the hook, there is room ah, how will be full. Check the server disk space, there are more than 5G, also enough. It was later found that there was an option below the automatic growth of the file, which grew by a few percent, by default 20%. 20% of the 20M is 4m,19m+4m is 23M more than the limit, so will appear that hint. Change the automatic growth to 10% and solve the problem. |
