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