?
Solved

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

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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