Solved

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

Posted on 2010-08-12
6
1,129 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Trying to Connect to SharePoint Site in PowerApps 5 48
Sharepoint 2010 Audit Logs 11 147
Sharepoint data after Hyper-V restore 4 27
SharePoint Online Collect Data in an Email 1 49
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…

735 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