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.

  • 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 Sep 19 '16 at 11:39

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

If you have changed your domain name for the SharePoint site, than you will not be able to retrive 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, privacy policy and cookie policy

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