• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2041
  • Last Modified:

SharePoint 2010 MySite Restore

We just started using SharePoint 2010 and having been testing the MySite Options.

I have a the MDF and LDF copies of the MySite Datase from Aug 31st and would like to restore them to SharePoint 2010.  

What is the best way to recover this database?

Thanks
0
acastellano
Asked:
acastellano
  • 4
  • 4
1 Solution
 
Justin SmithSr. System EngineerCommented:
Are your backups from the existing 2010 mysites?  Or are they from 2007?
0
 
acastellanoAuthor Commented:
Existing 2010 mysite.   I just made some changes/deletes and would like to test the restore back to Aug 31st.
0
 
Justin SmithSr. System EngineerCommented:
-make copies of existing SQL db's.
-detatch db
-replace files with the old copies of mdf/ldf
-attache db
-test in SharePoint
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
acastellanoAuthor Commented:
Strange, when I do this, the MySite Profile photos are now missing.
Is there data stored in other locations beside (in my case) wss_content_mysite database?
0
 
Justin SmithSr. System EngineerCommented:
profile db
0
 
acastellanoAuthor Commented:
I restored "User Profile Service Application_ProfileDB", but still dont see the Profile photos.
Is there another step I am missing or should I also restore "User Profile Service Application_SocialDB" and/or "User Profile Service Application_SyncDB"?
Thansk
0
 
Justin SmithSr. System EngineerCommented:
you need to restore all the profile app related databases.  that would include sync and social.
0
 
acastellanoAuthor Commented:
Just tried that and still do not see the Profile Pictures and Colleagues, but at least I am able to recover the attachments.
I will continue testing to see what I step I am missing.
Thanks

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now