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.
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.
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With