Solved

Restore SSP, MySites and User Profile info to test MOSS 2007 server

Posted on 2010-08-12
6
1,078 Views
Last Modified: 2012-05-10
I have a production MOSS 2007 server that I am doing full Server Farm backups using:

stsadm.exe -o backup -directory "\\BackupServer\BackupShare" -backupmethod full

I have built a new MOSS 2007 server from scratch. I am using the built in Central Admin Restore to do restores. I have restored the main portal sites. However, I am unable to restore the SSP backup which has the user profile info.

Can someone give me step by step instructions on how to  restore the SSP, User Profile, and MySites from the production server (which is still running) to my test server?

Thanks
0
Comment
Question by:shofarslee
  • 4
  • 2
6 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33423767
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 100 total points
ID: 33423780
0
 

Author Comment

by:shofarslee
ID: 33424029
Thanks for the link.

One question: it looks like this is for moving the SSP. However, I want the keep the SSP from the original server. I just want to restore a copy of the user profile and my sites info onto the test server.

The test server has an ssp and my sites set up - but are empty (and can be removed if necessary to restore from the production server).

Thanks
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:shofarslee
ID: 33908714
The link doesn't give any detailed instructions. I tried restoring the SSP from backup, but it fails. I've tried building a new SSP from scratch, and attaching the My Sites content database - but there is no user profile information.

The user profiles is the main thing I'm after.

Thanks
0
 

Assisted Solution

by:shofarslee
shofarslee earned 0 total points
ID: 34872460
Ok here's what finally worked. (This is also posted elsewhere under a different question where the solution ended up being the same).

1) Restored the SSP via SharePoint restore.
2) Created a new tempSSP and made it the default SSP (did this so I could do the next step of deleting)
3) Deleted the original SSP - but didn't delete the SSP database (SharedServices1_DB)
4) Created a third final SSP (we'll call it FinalSSP) - and attached the restored SSP database (SharedServices1_DB)
5) Also manually created new Web Apps and Content database for the MySite
6) Deleted the default Content MySite Database
7) From a SQL restore, attached the production MySite content database

This allowed me to get all the profile information and have it show up along with the user's MySites.

Thanks
0
 

Author Closing Comment

by:shofarslee
ID: 34904788
Gave some points for some helpful information, but ended up finding the solution on my own.

Thanks
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

12 Experts available now in Live!

Get 1:1 Help Now