Failed to allocate a new page for the database due to insufficient disk space in the filegroup

Question

when I run the program in SAS connected to SQL Server 2008, I get this ERROR in the log:

Runtime error: ICommand :: Execute failed .: The application was terminated: Failed to allocate a new page for the databse database due to insufficient disk space in filegroup 'CURRENT01'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting up startup for existing files in the filegroup.

I look at similar problems and I cannot see a solution. I am absolutely sure that we have enough space in the database. maybe something related to work? I am brand new with SQL Server.

Thank you in advance for your help.

Answer 1

For such errors, your database takes up disk space, not the space available for the database, this happens when you perform a bulk insert operation (mostly).

You can see it by clicking database -> Properties -> Files -> Database - space available and size.

Try to drop some tables, and then let go of the space.

Answer 2

. , , , .

Management Studio: → → → Autogrowth/Max Size.

, , , .