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 - 2008-01-07 : 22:50:59
|
| Primary file group is full for one user dbThis is production serverTotal db size is 132186 MBdata file is 12000 MB, set automatically growand restrict file growth is 121024 MBNow there is 30 GB space on driveI have added space to file 3 times(1GB, 10GB, 3 GB) and incresed restrict file growth also(5GB). database is in simple recovery mode.stille I am getting above error, pleasee let me know how to proceed now? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 23:24:21
|
| What do you mean total db size? Data plus log? If you get file group full error, that means db needs more space. |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-01-08 : 21:09:30
|
| yep data plus logBelow are the details for db space used. database_name database_size unallocated space -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ databse name 147693.20 MB -20458.09 MB reserved , data , index_size , unused ------------------ ------------------ ------------------ ------------------ 159694936 KB 93924280 KB 55293752 KB 10476904 KB Could you please suggest how much free space can we add to the db primary file group? Or suggest how to proceed further? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-08 : 23:26:22
|
| Run 'sp_spaceused @updateusage = true' first to find out how much free space in the db, then find out data growth rate. If don't know then don't set restriction. |
|
|
|
|
|
|
primary file group is full