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 |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2006-07-28 : 02:31:37
|
Server: Msg 1101, Level 17, State 2, Procedure A_SP_SubPillarType, Line 34Could not allocate new page for database <DB Name>. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth.Can anybody tell me what error is this.thanks in advance,Mahesh |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-07-28 : 04:04:22
|
| The error message tells you what the error is and how to fix it.-------Moo. :) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-28 : 04:57:13
|
| Your disk is full, or you have a fixed space allocated to your database, and that is now full.Check the size of the MDF and the LDF files. If the LDF file is massively larger than the MDF your transaction log is not being backed up - come back with that news and we can help you sort that out.Otherwise delete some data or increase the size allocated to your database, or delete some files from your full disk!Kristen |
|
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-07-28 : 06:00:09
|
Thanks Buddies. I set the "Autometically Grow file" option to Yes. Its working well. But one more thing, i couldn't understand technical reason. can anybody explain?Thanks again,Mahesh |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-28 : 06:21:24
|
| If Automatic Grow File was OFF then there was a limit on the filesize - and as you add data to your database, or perform other actions, the database will grow - and eventually fill the allocated space.Kristen |
|
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-07-28 : 06:27:47
|
| thanx kristenBMahesh |
|
|
|
rsprabhu
Starting Member
5 Posts |
Posted - 2006-08-10 : 04:40:55
|
| Can you tell me where to look for "Autometically Grow file" option in SQL Server Management Studio???r,Prabhu |
|
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-08-10 : 08:38:12
|
| look it into SQL Server Enterprise Managerin the tree view of DB architecture, right click on the database and select Properties then select the second tab named DATA FILES. u will get there Autometically Grow File check box in File Properties. u can also define file growthMahesh |
|
|
|
|
|
|
|
|
Could not allocate new page for database