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,439 of 19,505   
   Erland Sommarskog to Gene Wirchenko   
   Re: Thousands of Files in "c:\Documents    
   08 Sep 11 15:38:44   
   
   From: esquel@sommarskog.se   
      
   Gene Wirchenko (genew@ocis.net) writes:   
   >      I have written about this before, have searched for answers   
   > before, and I still do not have a solution.   
   >   
   >      Thousands of 368-byte files are being created in "c:\Documents   
   > and Settings\LocalService\Application   
   > Data\Microsoft\Protect\S-1-5-19".  How do I get this to stop?   
   >   
   >      Even deleting these files can take hours.  There are that many.   
   > Running a chkdsk can take a lot longer than usual when there are a lot   
   > of these files on my system.   
   >   
   >      From my searching, I understand that it may be due to Reporting   
   > Services and a cryptokey problem, but I know of no way to stop it.   
      
   I have no ideas what that may be. On this computer I have to directories   
   under Protect with a SID in the directory name. One directory has a single   
   file with a GUID name and a file Preferred. The other directory has five   
   such files + "Preferred". But this is a netbook which I rarely use when   
   I'm at home, but right now I am travelling. There is no Reporting Services   
   on this machine.   
      
   I can see that the latest such file is from Aug 22nd, which is about the   
   day I took out the netbook to prepare it for the trip.   
      
   One idea would be to write a program in the language of your choice which   
   deletes all files but the latest, and run it from Task Manager or SQL   
   Server Agent regularly.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- 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