Solved

SharePoint 2010 MySite Restore

Posted on 2010-09-13
8
1,986 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now