ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup . Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Fix/Workaround/Solution:
Make sure there is enough Hard Disk space where database files are stored on server.
Turn on AUTOGROW for file groups.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
I am still getting the same error after shrinking the tempdb and change it to unrestricted grow.
Hi Tariq,
Please look at this post :
http://blog.sqlauthority.com/2007/08/08/sql-server-2005-ssms-enable-autogrowth-database-property/
Regards,
Pinal
Just to update you, the reason I was getting the same error even after selecting unrestricted grow for tempdb because my HD was full temp db went up to 30GB. I looked at the sp to see what the hell its doing. Sp has almost 75 to 100 case statement. I don’t know how to make that sp better. Any idea? Thanks
Hi Tariq ,
I have some Tips for you ,
1) Tempdb Allways be on another drive not defoult will help you to increase Performnace ! whenever your SQL server starts it recreate the Tempdb with your defoult size .
2) If you would like to tune your SP’s then you can use Indexs in frequenty use tables ! (Its all about logics and delopments , Less scanning table will give you less execution time , 100 case doesnt matter some we use 1000’s of cases !)
3) If you face a tempdb size problem the , only tempdb is the database which you can move online .
I hope Tips will inline your needs .
Cheers
Praveen
Guys,
I had the same issue, and I applied all the advices that you posted. Thank you very much for sharing your experience.
I’d like to share mine too:
The problem I had was the fact that MS SQL Server 2005 Express has the database size limit of 4GB. I had a few big tables in there, so when I deleted the tables that I don’t need, I got rid of the error that we’re discussing here.
That’s it.
Take care,
Alex.