sql server 2008, not enough disc 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:22 UTC
Read the original article Hit count: 204

Filed under:
|

Hello,

Im 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 disc 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 Im doing ?

Thanks for help

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008