What To Do When There Is Not Enough Space Left For Log Files?

After an INSERT INTO ... SELECT ... FROM ... query (and after waiting for ~40 minutes) I got the following errors:





Code Snippet

Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 164288922910720' 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
I checked the space in the disk partition and it has only 10MBs left, so clearly there isn't enough space left.

I need a quick solution, and since I know nothing about logs and db backups in SQL Server, I thought to install SQL Server 2005 in another PC with a 30GBs primary partition for XP and applications and a 350GBs empty partition which would be enough for log files. So my question is how to setup SQL Server 2005 to use that big partition.