Sorry if this is in an FAQ somewhere, but I can't seem to find an answer.   
      
   I have SQL Server 2008 "Developer Ed."  (one instance) installed on a   
   Win7 64bit machine. By default, it appears to place it's internal cache files   
   (ie *.cache) in the:   
      
   	"C:\Users\{Sqladmin}\AppData\Local\temp\*"   
      
   directory. The instance itself is installed on a different local drive, and I   
   have   
   another local scratch drive, as well as a 2 Terabyte Raid10 stripped &    
   mirrored   
   RAID for the filegroups.   
      
   I tend to leave the instance running constantly, and thus, the directory fills   
   up and has almost crashed the system once or twice. I would like to alter   
   SQL Server to re-direct these cache files to a directory on the scratch volume,   
   where there is much more space, and at least the system won't be in danger   
   of crashing.   
      
   Is there any way to alter the drive/directory designation for these cache   
   files?   
   I've searched through all the help and docs and cannot seem to find how to   
   do it, if at all possible...  I'd be willing to re-install SQL Server if   
   necessary.   
   It's only a developer ed.   
      
   Thanks so much in advance.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)