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


  1. Posts : 4
    Windows 10
       #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.
    Why do sql profiles in c:\users repeat the files in "Documents"?-image1.jpg
    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:
    Why do sql profiles in c:\users repeat the files in "Documents"?-image2.jpg
    In the documents folder, you can see in the following image that it has over 8 gig of data.
    Why do sql profiles in c:\users repeat the files in "Documents"?-image3.jpg

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


  2. Posts : 4,224
    Windows 10
       #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 Computers


  3. Posts : 4
    Windows 10
    Thread Starter
       #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 Computer


  4. Posts : 261
    Windows 10 Pro 21H2 (OS Build 19044.1706)
       #4

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


  5. Posts : 1,773
    Windows 10 Home
       #5

    jrmocfl said:
    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 Computer


  6. Posts : 1,680
    X
       #6

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


  7. Posts : 4
    Windows 10
    Thread Starter
       #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 Computer


  8. Posts : 4
    Windows 10
    Thread Starter
       #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.

    Why do sql profiles in c:\users repeat the files in "Documents"?-delete.jpg
      My Computer


  9. Posts : 4,224
    Windows 10
       #9

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


 

  Related Discussions
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 16:58.
Find Us




Windows 10 Forums