Solved

SharePoint 2010 MySite Restore

Posted on 2010-09-13
8
2,004 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 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