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

Discus and support Why do sql profiles in c:\users repeat the files in "Documents"? in Windows 10 Support to solve the problem; Good for you! Please report back here if anything odd or unexpected happens as a result. Thanks for letting us know. --Ed-- Discussion in 'Windows 10 Support' started by EdTittel, Apr 4, 2018.

  1. EDTITTEL
    EdTittel Win User

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


    Good for you! Please report back here if anything odd or unexpected happens as a result. Thanks for letting us know.
    --Ed--
     
    EdTittel, Apr 4, 2018
    #1
  2. JRMOCFL
    jrmocfl Win User

    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"? [​IMG]

    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"? [​IMG]

    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"? [​IMG]


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

    :)
     
    jrmocfl, Apr 21, 2018
    #2
  3. EDTITTEL
    EdTittel Win User
    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--
     
    EdTittel, Apr 21, 2018
    #3
  4. JRMOCFL
    jrmocfl Win User

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

    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.
     
    jrmocfl, Apr 21, 2018
    #4
  5. KYLE
    Kyle Win User
    Generally speaking, it shouldn't take much space at all.
     
    Kyle, Apr 21, 2018
    #5
  6. MRGEEK
    mrgeek Win User


    For the amount of space these take up, it's not worth breaking anything unless you run a good imaging program first.
     
    mrgeek, Apr 21, 2018
    #6
  7. MARGRAVE55
    margrave55 Win User
    If it aint broke don't fix it. *Smile
     
    margrave55, Apr 21, 2018
    #7
  8. JRMOCFL
    jrmocfl Win User

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

    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
     
    jrmocfl, Apr 21, 2018
    #8
  9. JRMOCFL
    jrmocfl Win User
    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"? [​IMG]
     
    jrmocfl, Apr 22, 2018
    #9
Thema:

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

Loading...

  1. Why do sql profiles in c:\users repeat the files in "Documents"? - Similar Threads - Why sql profiles

  2. are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same location?

    in Windows 10 Gaming
    are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same location?: are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same?why or why not? New Windows 11 PC and I'm completely confused by OneDrive .. can't find anything I save a second time .. I think i'm creating two copies of everything.can I just delete it OneDrive...

  3. are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same location?

    in Windows 10 Software and Apps
    are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same location?: are C:\Users\myname\OneDrive\Documents and C:\Users\myname\Documents the same?why or why not? New Windows 11 PC and I'm completely confused by OneDrive .. can't find anything I save a second time .. I think i'm creating two copies of everything.can I just delete it OneDrive...

  4. Files in folder "Documents" C:\Users\NAME\Documents disappeared / folder empty

    in Windows 10 Network and Sharing
    Files in folder "Documents" C:\Users\NAME\Documents disappeared / folder empty: Hello to everyone, I'd really be grateful for any help on this issue - thank you very much!The problem:Two days ago, while my laptop was running i.e. not after a Windows Update reboot, all files in all subfolders located in C:\Users\NAME\Documents have disappeared "This...

  5. Files in folder "Documents" C:\Users\NAME\Documents disappeared / folder empty

    in Windows 10 Software and Apps
    Files in folder "Documents" C:\Users\NAME\Documents disappeared / folder empty: Hello to everyone, I'd really be grateful for any help on this issue - thank you very much!The problem:Two days ago, while my laptop was running i.e. not after a Windows Update reboot, all files in all subfolders located in C:\Users\NAME\Documents have disappeared "This...

  6. User profile failed to load and sign-in & file recovery C/USERS

    in Windows 10 Network and Sharing
    User profile failed to load and sign-in & file recovery C/USERS: Hi, I powered up my laptop recently and I encountered a strange problem. At start-up, it couldn't load my Microsoft account - even if I entered the correct sign-in details "The user profile service failed the sign-in. User profile cannot be loaded.", so I restarted it and...

  7. Move my c:/Users/{profile} to the D:/users/{profile}

    in Windows 10 Network and Sharing
    Move my c:/Users/{profile} to the D:/users/{profile}: I have an SSD as the C: drive. and a large HDD as the D: drive. Windows 10 Pro Version 1909 I want to keep the stuff I do not use all the time off the SSD drive. I have two users Admin and {J} account. I want to move the working data for the {j} account to...

  8. "C:\Users\<username>\Documents\<File Folder name>"

    in Windows 10 Network and Sharing
    "C:\Users\<username>\Documents\<File Folder name>": "C:\Users\<username>\Documents\<File Folder name>" refers to a location that is unavailable. It could be on a hard drive on this computer, or on a network. Check to make sure that the disk is properly inserted, or that you are connected to the Internet or your network, and...

  9. File Explorer shows User Profile folder as Documents

    in Windows 10 Network and Sharing
    File Explorer shows User Profile folder as Documents: I Accidentally merged the Documents folder with my User Profile folder (actual title is "User"). I could move Documents folder to <User Profile>\Docements folder only by editing Registry. Now Documents folder operates correctly in Explorer (in This PC and Quick Access). But...

  10. C:\Users\xxx\Documents

    in Windows 10 Customization
    C:\Users\xxx\Documents: There's one question I always wonder. We all know drive C is for system and software program files Why does Windows set default "Documents" folder (Pictures, Music, Download...) path in drive C? And users have to move them to other drive after installing new windows or never...