Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint 2010 MySite Restore

Posted on 2010-09-13
8
Medium Priority
?
2,028 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
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…

618 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