Solved

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

Posted on 2010-08-12
6
1,122 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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