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

1 Answer 1


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.

  • 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.. May 18, 2010 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! :-) May 18, 2010 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, 2010 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. May 20, 2010 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 :-) May 20, 2010 at 19:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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