December 13, 2005 at 11:59 pm
Hi all,
In one of my production box I get this error
Error: 1105, Severity: 17, State: 2 Could not allocate space for object (SYSTEM table id: -154740037) in database weXXX_PRO_df because the PRIMARY filegroup is full.
If I go to database property to see if there is sufficient space what i see is max file size is set to automatically grow file.
I have checked for space in the drive and there is suffient space. ( I am running optimization job during the time of this alert. Will this have an effect)
the size of DB : 24.5 GB
space available is : 6.9 GB
Helen
--------------------------------
Are you a born again. He is Jehova Jirah unto me
December 14, 2005 at 7:14 am
Better avoid running optimization job during time of alert.
Check the size of tempdb as well. If tempdb is on another drive say c
and there is no space for growth you end up with problem.
First try xp_fixeddrives and check the size of alldisk and also check the autogrow option.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
December 15, 2005 at 10:53 am
To add up to the above. If you have a single table of a huge size, you might need to increase the size of a temp db to fit it in.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply