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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2007-12-19 : 20:26:03
|
| I got below error :Could not find allocate space for object 'tablename' in DB, because the primary file group is fullUpon investigation I found :datafile is reached it's maximum sizeDB Size space allowcated 197 MB, space free 20.69 MBDB mdf 194880 KB, ndf 6272 KBIt's production server, please let me know how to proceed now? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-19 : 20:32:11
|
| Do you have autogrow enabled on the database? How much free disk space is there on the drive where this MDF file is located?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-19 : 20:48:22
|
| Yes autogrow is enabled on the database. There is 20 GB space on the drive which this MDF file locateddo I need to shrink the datafile ?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 20:52:23
|
| No, you may need allocate more space to it manually instead. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-19 : 22:02:28
|
| I have increased data file growth to 300 MB (10%)But it is a production server, so can I set it to unrestricted growth? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 22:39:55
|
| Sure if disk has enough free space. |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-12-19 : 22:55:36
|
| Thanks alot, I really appriciate all your help! |
|
|
|
|
|
|
primary data file group is full