Could not allocate space for object...
Hi since few days we are getting below error message on System Center Essential 2007 server every second in event viewer for application... " Could not allocate space for object 'dbo.PerformanceData_21'.'idc_PerformanceData_21_TimeSampled' in database 'OperationsManager' 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. " server has enough gb free space on OS and Updates partions... Any suggestions...
February 6th, 2008 3:46pm
Hi All, The same problem for me and DB are configured to autoexpand without limits and the server has a lot of free disk space... "Could not allocate new page for database. There are no more pages available in filegroup" "Could not allocate space for object in database because the filegroup is full" Tnx in advance. Red.
February 7th, 2008 3:23am
Hi Tejas,I'd like to suggest you increased the size of the OperationsManager database using the SQL Server Management Studio. Connect to the server running the OpsMgr Operational Database, open the server/databases, right-click on the OperationsManager database (default name) and click properties. Click on the files tab, change the MOM_DATA size to the new size and click Ok. You can validate that the change in size occurred by going back to the properties of the database.--------------------Regards,Eric ZhangMicrosoft Online Community Support
February 8th, 2008 1:30am
Thanks Eric, We are fine now after doing steps you suggested... Thanks for your time and suggestion.. Tejas
February 8th, 2008 4:26pm
Hi,I know that this is a close thread, but i'm having the same problem. I get the error "Coul not allocate space for table XXXX because the Primary Filegroup is FULL".I already check all the options of growth and everything is OK.The Autogrowth is configured withou limitation and have above of 20GB of diskspace, so it's almost impossible that the database growth that much, because the datafiles have already assigned 15 GB and 10 of that 15 GB are free, i mean the datafile have internal freespace.But still i'm getting this error when a DTS Package make a transfer of rows from one server to another.The only particularity is that the table have defined a column of IMAGE Datatype. But i already check that the size of all the bulk of data is normal and pretty far from fill the datafile to its capacity and make it grow.The solution you put here i think its not the case for me, but i wanna to know the fundations of the answer i mean, why if everything is set OK in the options this kind of behavior takes place.I hope you could answer my doubts.Regards!Diaz, Cristian Andres
December 22nd, 2008 2:20pm
Please check if you are not using SQL Express, it has a license limit of 4G per database.
September 11th, 2011 4:26am