Why do sql profiles in c:\users repeat the files in "Documents"? Solved

  1.    21 Apr 2018 #1

    Why do sql profiles in c:\users repeat the files in "Documents"?


    I was looking at c:\users and found the additional profiles other than my own, jrmoo.
    Click image for larger version. 

Name:	image1.jpg 
Views:	28 
Size:	143.4 KB 
ID:	185554
    What troubles me is that if I do a directory listing, I find the same folder structure and in the Documents folder, find the same duplicated files that are in my main profile. Why does installing sql server and reporting services do this?
    Here is an example of the last profile:
    Click image for larger version. 

Name:	image2.jpg 
Views:	28 
Size:	48.6 KB 
ID:	185555
    In the documents folder, you can see in the following image that it has over 8 gig of data.
    Click image for larger version. 

Name:	image3.jpg 
Views:	2 
Size:	68.1 KB 
ID:	185557

    Is this normal? Why the repetitive data?
    Thanks in advance!
    James
      My ComputerSystem Spec

  2.    22 Apr 2018 #2

    It's been a while since I dug into this, but these accounts and folders are all related to an MS SQL Server's so-called "service accounts" and related file system infrastructure. You can learn a bit more about this from this StackOverflow thread: How to create a Windows service account for MS SQL Server in a workgroup environment? - Stack Overflow. To really suss this out, you'll need to dig into the MS SQL Server documentation and maybe a good SQL Server book.
    But, to answer your basic question "Is this all normal?" the answer appears to be "Yes, it is."
    HTH,
    --Ed--
      My ComputersSystem Spec

  3.    22 Apr 2018 #3

    Thanks for the tip, EdTittel. So, are you saying that you think it is possibly normal to copy over every single folder and file from my main user profile and duplicate it in these sql server profiles? If so, what a waste of hard drive space.
      My ComputerSystem Spec

  4.    22 Apr 2018 #4

    Generally speaking, it shouldn't take much space at all.
      My ComputerSystem Spec

  5.    22 Apr 2018 #5

    jrmocfl said: View Post
    is possibly normal to copy over every single folder and file from my main user profile and duplicate it in these sql server profiles? If so, what a waste of hard drive space.


    For the amount of space these take up, it's not worth breaking anything unless you run a good imaging program first.
      My ComputerSystem Spec

  6.    22 Apr 2018 #6

    If it aint broke don't fix it. :)
      My ComputerSystem Spec

  7.    22 Apr 2018 #7

    Even if there is a total of over 50 gigs in this combined folders that is duplicated from my main profile?

    It wouldn't do any harm to delete these folders, would it?

    C:\Users\MSSQL$SQL2016
    8,445,399,547

    C:\Users\MSSQLFDLauncher$SQL2016
    8,423,122,352

    c:\uses\mssql$sql2016
    \8,445,399,547

    C:\Users\MSSQLLaunchpad$SQL2016
    8,423,454,685

    C:\Users\ReportServer$SQL2016
    8,425,346,879

    C:\Users\SQLTELEMETRY$SQL2016
    8,425,346,879

    Total GIG = 50,588,069,889
      My ComputerSystem Spec

  8.    23 Apr 2018 #8

    I am happy to report that I deleted every single folder w/ files in the above SQL user profiles except what is shown in the image below and my local SQL server and reporting services are working just fine. I also freed up over 50+ gig of duplicated data from my main profile.

    Click image for larger version. 

Name:	delete.jpg 
Views:	8 
Size:	7.3 KB 
ID:	185743
      My ComputerSystem Spec

  9.    23 Apr 2018 #9

    Good for you! Please report back here if anything odd or unexpected happens as a result. Thanks for letting us know.
    --Ed--
      My ComputersSystem Spec


 

Related Threads
Hi, as with many I have upgraded to Windows 10 today and it is going well except for the fact I am unable to save any files or create new ones in the Documents and Pictures folders or any sub-folders within these folders, and I have no idea why it...
Hi I have recently updated to the creator version My files end up in unintended destinations. When I click in the documents tab in the sidebar of the documents screen, it takes me to a “Documents” folder that appears in “One Drive” group. Any...
When I did a new install of Windows 10, my user name changed from 'Dave' (in Windows 7) to 'doher' (in Windows 10). At the time I was not happy about it, but too many things eventually tied to the new name I just decided to stick with it. In Win...
How to Unlock "Users\All Users\Documents folder in User Accounts and Family Safety
The general method to change ownership is not working Please suggest some other method
Hi, I can't figure out how to change the part that says my name to something that is not my name. I have been trying to figure it out for a while and I also did not know what to search to find the answer online so can someone please help me
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 00:26.
Find Us