home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,102 of 19,505   
   Erland Sommarskog to zmpmag3-msql@yahoo.com   
   Re: SQL 2008 Cache File Relocation?   
   25 Jan 11 13:09:48   
   
   From: esquel@sommarskog.se   
      
    (zmpmag3-msql@yahoo.com) writes:   
   > Only those agents that were the "defaults" upon installation are   
   > running.   
      
   If you have Agent jobs running, they have been added by someone. There are   
   no jobs installed by default when you install SQL Server. What jobs do you   
   have there?   
      
   > And I don't necessarily want to stop them. I just want to relocate these   
   > cache files off my C: drive to keep it from filling and crashing the   
   > system.   
      
   It will probably work if you change the TEMP and TMP environment variables   
   for the SQL Service account. The easiest way is probably to log into Windows   
   as the service account for Agent, and then use Control Panel. You probably   
   have to restart SQL Server Agent.   
      
   Then again, the best for you is probably to stop these jobs from running.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca