Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsarnie
Starting Member
18 Posts |
 Posted - 2010-02-01 : 05:16:29
|
| Hi,I am getting an error:Could not allocate space for object 'dbo.SORT temporary run storage: 141082630684672' in database 'tempdb' 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.Please help.Let me know what steps I should take.Thanks and regardsArnie, |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-02-01 : 06:13:34
|
| Get more disk space if the tempdb is filling up, else, post what is actually running or think of another way to run your process. |
 |
|
|
mymatrix
Starting Member
24 Posts |
Posted - 2010-02-01 : 07:09:36
|
| In case of heavy log files, clean up log files for different databases after proper backup. that would free up some space.Allocate more space to db by changing settings.thnksGauravEven my blood group says be -ve to all the negatives. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-01 : 07:42:04
|
Also check that TEMPDB is set to AUTOGROW, rather than having a Fixed Size. If fixed size your query is too big to fit in the existing size  |
|
|
|
|
|
|
temp db full