Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-08-18
2
Medium Priority
?
3,685 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 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Integration Management Part 2

916 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