Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1184
  • Last Modified:

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
0
shofarslee
Asked:
shofarslee
  • 4
  • 2
2 Solutions
 
Justin SmithSr. System EngineerCommented:
0
 
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
Industry Leaders: 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!

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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now