Solved

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

Posted on 2010-08-18
2
2,948 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
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now