?
Solved

SharePoint 2010 MySite Restore

Posted on 2010-09-13
8
Medium Priority
?
2,026 Views
Last Modified: 2012-05-10
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
Comment
Question by:acastellano
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33664498
Are your backups from the existing 2010 mysites?  Or are they from 2007?
0
 

Author Comment

by:acastellano
ID: 33664512
Existing 2010 mysite.   I just made some changes/deletes and would like to test the restore back to Aug 31st.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33664601
-make copies of existing SQL db's.
-detatch db
-replace files with the old copies of mdf/ldf
-attache db
-test in SharePoint
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:acastellano
ID: 33664921
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33665391
profile db
0
 

Author Comment

by:acastellano
ID: 33666411
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
 
LVL 38

Accepted Solution

by:
Justin Smith earned 2000 total points
ID: 33671418
you need to restore all the profile app related databases.  that would include sync and social.
0
 

Author Comment

by:acastellano
ID: 33671950
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question