SQL 2005 temp directory

By ssharp ·
Hello all, I have a sql 2005 server and the c drive is running out of space. The maintenance plans use c:\temp and the space rapidly decreases until all the space is gone and the plan fails.

I want to change the temp directory to reside on another drive but am not sure how to do this as I don't have much experience with sql 2005. How can I change this in Sql and will it require any down time? Can the dbs stay online?
Any help would be appreciated. Thanks.


This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums