Solved

Move content databases between SHarePoint Farm

Posted on 2011-02-11
3
788 Views
Last Modified: 2012-05-11
We have SharePoint 2007 production and stage farm. I would like to refresh stage farm with the data from production farm. I did restore content and Mysites databases (we have one for each) on stage. Everything went well I can access sites and mysites on stage portal but with one issue.
We have customized mysites with lot of employee data displayed on the page which are obviuosly stored in SSP database. With the restore profile properties are not updated.
For ex: If open my mysite on stage, data which are being displayed on mysite is not the same as in production mysite. I think restoring mysites db doesn't really updates the SSP db.

Do I need to restore prod. SSP db on stage separately??, if I did would it break the link to profiles?? or is there any other way through sql script to update SSP properties??

Thanks in advance.
0
Comment
Question by:BoozTech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 500 total points
ID: 34873979
I've never had much luck moving SSP databases between servers. Always followed this:

http://technet.microsoft.com/en-us/library/cc896556(office.12).aspx

I actually think this is the only supported way, seems like I've heard that somewhere :)
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 34873987
0
 

Author Comment

by:BoozTech
ID: 34890226
I did use the SP Profile migrator and it worked. Thanks for yout comments.
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

707 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