How to allow SQL Server 2005 and/or TempDB to use multiple disk drives for storage space?
Posted on 2006-11-17
I am running SQL Server 2005 Developer edition on my home machine and i'm trying to execute a query that takes up most of the available space when I try to run it. I have some other drives other than C on the computer that have 250+ GB available. Is there any way to tell SQL Server it can use that space to expand into?
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 172560247422976' 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.
Msg 9002, Level 17, State 4, Line 1
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
If it helps the log_reuse_wait_desc column says nothing.