SQL Server 2008, not enough disk space

Posted by snorlaks on Stack Overflow See other posts from Stack Overflow or by snorlaks
Published on 2010-06-16T19:20:04Z Indexed on 2010/06/16 19:32 UTC
Read the original article Hit count: 292

Filed under:
|

Hello,

I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space.

I have also C drive which has sth like 150 MB free (right now).

While executing that query on quite a big table (16 GB) I have an error:

An error occurred while executing batch. Error message is: Not enough disk space.

I would like to know if there is any possibility that I can make SQL Server to use D drive instead of C

Or maybe there is any other problem with what I'm doing ?

Thanks for help

© Stack Overflow or respective owner

SQL Server 2008, not enough disk space

Posted by snorlaks on Server Fault See other posts from Server Fault or by snorlaks
Published on 2010-06-16T19:20:04Z Indexed on 2010/06/16 19:43 UTC
Read the original article Hit count: 293

Filed under:
|

Hello,

I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space.

I have also C drive which has sth like 150 MB free (right now).

While executing that query on quite a big table (16 GB) I have an error:

An error occurred while executing batch. Error message is: Not enough disk space.

I would like to know if there is any possibility that I can make SQL Server to use D drive instead of C

Or maybe there is any other problem with what I'm doing ?

Thanks for help

© Server Fault or respective owner

Related posts about sql

Related posts about sql-server-2008