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

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
shofarsleeAsked:
Who is Participating?
 
Justin SmithSr. System EngineerCommented:
0
 
shofarsleeAuthor Commented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
shofarsleeAuthor Commented:
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
 
shofarsleeConnect With a Mentor Author Commented:
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
 
shofarsleeAuthor Commented:
Gave some points for some helpful information, but ended up finding the solution on my own.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.