July 8, 2008 at 8:30 am
Hi,
I am trying to retreive data from a temporary table which I have inserted into in the same sp.
I get this error.
Could not allocate space for object 'dbo.SORT temporary run storage: 190806775300096' 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.
There is space in tempdb data and log file. nothing else is running on the server at the time. there is space on the disk. log_reuse_wait_desc is stated as NOTHING. I've stopped and started sql server to empty tempdb
Any ideas?
thanks
Adrian
July 8, 2008 at 8:34 am
Hi
Could you please run the following command and post the results here?
sp_helpdb tempdb
July 8, 2008 at 8:38 am
thanks for your quick reply!
tempdb 2048.00 MBsa2Jul 8 2008Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics90
tempdev1x:\MSSQL\DATA\tempdb.mdfPRIMARY1048576 KBUnlimited10240 KBdata only
templog2y:\MSSQL\DATA\templog.ldfNULL1048576 KBUnlimited10240 KBlog only
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply