Where the User Profile Pictures are stored in database? And in which database is it?

I've lost all the users' photos in high resolution from SharePoint Profiles and trying to find the way to restore these.

  • 1
    If the hq pictures have been lost in SP, you could just re-do the picture synchronization on UPSA. It's basically harmless to overwrite the whatever pictures users have on their profiles currently by the ones imported with the synchronization.
    – moe
    Commented Sep 19, 2016 at 11:39

2 Answers 2


User Profile pictures are stored in the content database of MySites!

If you have changed your domain name for the SharePoint site, then you will not be able to retrieve it unless you change the path of the pictures using powershell may be.


If you are importing the User's picture from the AD, a full sync will fix it.

Basically User Profile Pictures stored in the User Photos/Profile Pictures folder on the root of mysite host url. Url will be like this " http://Mysite url/User Photos/Profile Pictures"

In this folder, you will be 3 sizes of a sing users.

If you have backup of your site, then restore it and copy the pictures from restored site to here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.