March 9, 2009 at 7:38 am
I created a maintainence plan for a database of size 63 gig, data files and log files are in autogrowth, both are in e:\. E:\ drive still have 9 gig of space free. My maintainence plan job fails every week, there are two jobs created by maintainence plan, one is for integrity check and the other for optimization. Integrity check succeeds where as optimization job fails. Here is the below an error message, it is sql server 2000.
"[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object '(SYSTEM table id: -829741378)' in database 'Media' because the 'PRIMARY' filegroup is full."
March 9, 2009 at 8:16 am
Check the properties on the primary filegroup. It may be set to have a limit of some sort.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2009 at 8:24 am
How's the growth of the tempdb and log file? I know we've had several problems with that on jobs.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
March 9, 2009 at 8:25 am
What do you mean by properties of primary filegroup, I checked on the properties of database, its on autogrowth option with unlimited growth.
thank you
March 9, 2009 at 8:25 am
The tempd db is normal, I dont see any problem with tempdb
March 9, 2009 at 12:47 pm
abhisek karki (3/9/2009)
I created a maintainence plan for a database of size 63 gig, data files and log files are in autogrowth, both are in e:\. E:\ drive still have 9 gig of space free. My maintainence plan job fails every week, there are two jobs created by maintainence plan, one is for integrity check and the other for optimization. Integrity check succeeds where as optimization job fails. Here is the below an error message, it is sql server 2000."[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object '(SYSTEM table id: -829741378)' in database 'Media' because the 'PRIMARY' filegroup is full."
It only has 9GB free on your SQL Data drive? I think you should add more space to that drive. Database might be set to auto grow but if you set the defaults on growth and on your 63gb database 10% growth is 6.3GB .. SQL might be trying to grow the DB but can't ...
Just a thought.. thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply