Sql-server – Error: ‘PRIMARY’ filegroup is full

filegroupssql server

We have increased disk space on the SQL Server, and there is definitely enough space on the server, yet below error is raised:

com.softmar.fileserver.WebFileException: com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.WebFileImage'.'pkWebFileImage' in database 'sslFileServer' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

The properties of the database shows that there is only 1.1 MB available, yet other databases on the same SQL server shows much more space available on the properties. So why is only this database not accommodating the disk size increase? Looking at the file settings it is set to unrestricted growth.

This is rather critical so will appreciate your swift response.

enter image description here

Best Answer

add a file to your database and set it's filegroup to primary.