Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We have taken over a site where My Sites are placed in the Intranet web application.

I want to migrate the My Sites to a dedicated host site.

From what i have been able to find out so far, I will need to do an STSADM -o backup of each personal site and restore it into the new content database.

I will be automating this process using PowerShell.

Has anyone tried this?

Any caveats i need to be aware of?

Since i need to move site collections out of an existing content database into another, as far as i can see i cannot use a simple SSP migration.

Any help appreciated :-)

EDIT: I wrote a blog post on how I solved this using stsadm mergecontentdbs here

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Have you considered using stsadm -o mergecontentdbs to move them all into a single content database and then attaching that content database to the new site host? I don't know for certain that this will work, but it seems like it would make the process much simpler and with less risk of data loss as the sites will still be available.

share|improve this answer
    
That's an interesting thought. I guess one thing to remember would be that it would only work if all the My Sites would fit into a single content DB (e.g. less than 100GB or whatever 'threshold' is being used) using quota x number of My Sites. Still, perhaps the approach could be used with multiple content DBs.. –  Chris O'Brien - MVP May 18 '10 at 13:34
    
Right now im testing a way i found on MS fora by Neil Hodgkinson where i use stsadm backup but with -item "intranet\mysites". This will mean i dont have to iterate all sites: social.technet.microsoft.com/Forums/en-US/sharepointadmin/… Will update if it works, but thanx for the suggestion! :-) –  Anders Rask May 18 '10 at 13:36
    
Let me know how it goes Anders. I know you are using powershell, would love to see what you came up with to make it work. –  Lori May 18 '10 at 14:09
    
Lori: mergecontentdbs was the key! I already had all in the same content db, that was the problem! I wanted to filter out all personal sites from the intranet content db & move them into another db in another webapp running my site host. I talked to Todd Klindt who also said mergecontentdbs was the key to splitting up the db using the stsadm command enumsites to feed it xml as described here toddklindt.com/blog/Lists/Posts/Post.aspx?ID=53 The xml is trimmed to contain only mysites. After that i moved the db from one webapp to another using deletecontentdb and addcontentdb. –  Anders Rask May 20 '10 at 19:29
    
After doing that i only needed to do a createsite command to add the my sites host, and i was up and running with my sites on seperate webapp :-) –  Anders Rask May 20 '10 at 19:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.