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.
| Author |
Topic |
|
dowens
Yak Posting Veteran
82 Posts |
 Posted - 2005-10-05 : 09:17:47
|
| Help, why did I receive a error message when I have 177G of free space?I receved this message last night. I use sp to build db.The size of the db is 12.9G, maxsize Unlimited, growth 10%.Current free space 117G.Msg 1105, Sev 17: Could not allocate space for object 'dw_MasterClaim_ProcLine' in database 'fl1stDwProd2' because the 'PRIMARY' filegroup is full. [SQLSTATE 42000]The tempdb size is 18.2G - this is the size after I did a stop/start is this the issue? I thought the tempdb was cleared after a stop/start? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-10-05 : 13:42:37
|
| TempDB typically should clear when you stop/start the services but I don't think that's your problem.Do you have autoshrink on for the 'fl1stDwProd2' database?DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
dowens
Yak Posting Veteran
82 Posts |
Posted - 2005-10-05 : 14:56:29
|
| Yes I do. |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-10-06 : 12:17:30
|
quote:
Originally posted by dowens
Yes I do.
The out of space problem is because the auto shrink is most likely occuring at the same time as the growth. I would not use the auto shrink feature.DanielSQL Server DBAwww.dallasteam.com |
|
|
|
|
|
|
HELP - Primary filegroup full