Solved

Move content databases between SHarePoint Farm

Posted on 2011-02-11
3
785 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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

772 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