Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Index

Author  Topic 

Samir
Starting Member

3 Posts

Posted - 2010-10-22 : 19:52:04
Could not allocate space for object 'dbo.SubjectTestResult'.'unci_SubjectTestResult_SID_SV_TID_TV_ED_RelID_RN' in database 'CSM_Reports' 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.

Dear All,

I'm new in SQL Data Base i have a problem with SQL 2005 SP3
we have a space for : 1TB HDD
Free Space is : 700 GB
Mydata base is : 20 BG

I'm using 3rd party application which write a records in SQL Data Base and i have the above error. and i change the autgrow to on
but still i have this problem please help me



Samir Saadah

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-10-23 : 01:40:17
what was space you alloted for default filegroup?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Samir
Starting Member

3 Posts

Posted - 2010-10-23 : 05:03:17
Dear sir,

The inital Space is 2404 MB and 200 MB with Unrestricted

Samir Saadah
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-10-23 : 05:10:06
http://www.banmanpro.com/support/filegroupfull.asp

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Samir
Starting Member

3 Posts

Posted - 2010-10-23 : 05:33:44
Dear Sir,

Thank a lot, i checks all of this parameter but still i have the same error


Samir Saadah
Go to Top of Page
   

- Advertisement -