sql server 2008, not enough disc space
- by snorlaks
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