Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #652

Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19"

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-07 18:18 -0700
  Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Erland Sommarskog <esquel@sommarskog.se> - 2011-09-08 15:38 +0200
    Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-08 15:22 -0700
  Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-09-09 09:47 +0100
    Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-09 11:45 -0700
      Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-09-09 15:33 -0400
        Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-12 11:07 -0700
          Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-09-12 14:19 -0400
            Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-12 12:02 -0700
              Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" "Andrew Morton" <akm@in-press.co.uk.invalid> - 2011-09-13 09:11 +0100
                Re: Thousands of Files in "c:\Documents and Settings\LocalService\Application Data\Microsoft\Protect\S-1-5-19" Gene Wirchenko <genew@ocis.net> - 2011-09-13 09:40 -0700

csiph-web