March 11, 2013 at 5:26 am
Hi Guys,
On the development server I noticed a file called SQL in C:\Users\sqlaccount\AppData\Local\Temp that has grown up to 10GB. The only way to get rid of it is to stop SQL Agent and delete file, but when i restart the agent the file is created again. It takes over a month to grow up to 10gb.
I can confirm the SQL Agent ERROR log file is pointing to a different drive.
Message in SQL log file
SQLAGENT 520-344EXIT SQLGetDiagFieldW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3
SQLHANDLE 0x00000000002D6740
SQLSMALLINT 1
SQLSMALLINT -1154
SQLPOINTER 0x000000001CFC871C
SQLSMALLINT -6
SQLSMALLINT * 0x0000000000000000
Any ideas what this is ?
March 11, 2013 at 5:31 am
suggest could be a trace file of some type - nothing on my systems like this, but I do have temp env vars set to a different drive.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 9, 2014 at 7:49 am
\AppData\Local\Temp is used by ACE drivers from the SQL instance (Providers in SSMS).
Are you using OPENROWSET or linked servers ? SSIS packages or SPs who load data with OPENROWSET ?
If Yes, you have your answer !
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy