Just find the database file and add a data file.
Solution: 1. Check whether your remaining disk space is sufficient. If there is no remaining disk space, clear the disk and free up space.
2. Check the format of your disk partition: If fat16 is used, the maximum data file size is 2 GB. If FAT32 is used, the maximum data file size is 4 GB.
, But the NTFS partition does not have this restriction.
3. Check whether you have restricted the size of database files:
Enterprise Manager-right-click your database-properties-file growth limit-remove the limit if there is a limit on the size.
4. Check your SQL version. If you use MSDE, the maximum data file size is 2 GB.
5. You can also add new data files to the primary group to solve this problem.
Alter database name Add file (name = logical file name, filename = 'C: actual file name. ndf '.
(In fact, it is more convenient to select the Database "attribute" in the Enterprise Manager.
Solve the problem by adding an NDF!