Solved

Could not allocate space for object 'dbo.SORT temporary run storage

Posted on 2010-08-18
2
3,075 Views
Last Modified: 2012-05-10
Hi,
I need to make an update to the size of a field in a table changing the length from 220 to 255.
When making the change in the design mode I come accross the following error
'GlobalFeed' table
- Unable to create index 'PK_GlobalFeed'.  
Could not allocate space for object 'dbo.SORT temporary run storage:  140737489600512' in database 'MyDatabase' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
The statement has been terminated.

I am not sure of the terminoligy of what I am required to do. looking at my system resources it appears that I have plent of spare space. the database size is 2.6gb on sql express 2008 so well within the 4gb limts. I don't know how to set the auto growth as sugested either.
Can anyone simplify the message as to what I should do to free up the space.
Cheers
0
Comment
Question by:Simon Cripps
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33466021
The error describes that your Database has reached the max size limit, that is restricting it from creating anything in the Database..

http://support.microsoft.com/kb/315512
http://blog.sqlauthority.com/2007/08/08/sql-server-2005-ssms-enable-autogrowth-database-property/
0
 

Author Comment

by:Simon Cripps
ID: 33466280
Many thanks, I have just notice that as well. I have removed a table, compacted the database and tried again and succeed.
Next step would be to upgrade to 2008 R2, but I can now postpone that for a bit.

0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question