Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Could not allocate a new page for database because of insufficient disk space in filegroup

while running a program in SAS conected to SQL-server 2008 I am getting this ERROR in the log:

Execute error: ICommand::Execute failed. : The statement has been terminated.: Could not allocate a new page for database 'databse' because of insufficient disk space in filegroup 'CURRENT01'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

I am looking to similar problems and I can not really see the solution. I am quite sure we have enough space in the database. is it maybe anything related with the work? I am quite new with SQL server.

Thank you, in advance, for your help.

like image 294
yke Avatar asked Aug 01 '14 08:08

yke


People also ask

Could not allocate space for object in database because the 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.

Could not allocate a new page for database SQL?

To resolve this issue, adjust your auto-growth settings for the database: Log in to SQL Server Management Studio with a user having sysadmin privileges. Expand System Databases, right-click the tempdb and click on Properties. Click Files in the left pane and then click on the ellipses button.

How do you setting Autogrowth on for existing files in the filegroup?

To do that, click on Files. In the right pane, click on a balloon in the Autogrowth / Maxsize column in ROWS File Type. A dialog box named Change Autogrowth for DemoDatabase opens. In the dialog box, set Maximum File Size to Unlimited.

What is SQL Server filegroup?

The filegroup contains the primary data file and any secondary files that aren't put into other filegroups. User-defined filegroups can be created to group data files together for administrative, data allocation, and placement purposes.


1 Answers

Check the settings of data file(s) in that file group. Most likely their upper size limit is capped in which case it does not matter if you have free space.

You can find these settings with Management Studio: right click the database -> Properties -> Files -> Column Autogrowth/Max Size.

You should also check that the database files are on the disk drive where you expect them to be.

like image 180
Marcel N. Avatar answered Sep 17 '22 16:09

Marcel N.