How to migrate SPS 2003 My Sites to MOSS 2007 using the same web app hosting the Portal site

During my customer’s migration from SPS 2003 to MOSS 2007 testing environment, we encountered some challenges while migrating My Sites. With Bill’s help, I was able to fix the My Sites in testing environment. During the actual production upgrade, My Sites were sucessfully migrated.

Here’s a recap of the fix I did in the MOSS testing environment:

1.       Migrate the portal content db first. 

stsadm -o addcontentdb -url -databaseserver dbserver -databasename portal_SITE

2.       Create a web named something like “my” using My Site Host template under the portal

stsadm -o createweb -url -sitetemplate SPSMSITEHOST -title “MySite Host”

3.       Then restore SSP from the old PROF db: 

stsadm -o restoressp -title Restored_SSP -url http://adminserver:11111 -ssplogin DOMAIN\sharepoint -mysiteurl -indexserver
indexservername -indexlocation “d:\index” -keepindex -sspdatabaseserver dbserver -sspdatabasename portal_PROF -ssppassword pwd

4.       Execute iisreset 

Then go into the SSP admin, check My Site settings, search settings, User profiles to make sure they all look good. 

5.       Now as a user, when I click on My Site in portal home page, I’m brought to and when I click on My Profile (or others click on my name) I’m brought to\userid

6.       To see the old SPS2003  MySite home page, just type . The Web Part error in this page is expected due to the retirement of My Alerts summary web part in MOSS 2007. Other web parts from your old MySite home page should show up here. This link can be pinned at either SSP or site level.

I’m also linking Bill’s blog here for further reference:

Comments (16)

  1. frankok says:


    I’m trying to restore a PROF database from a SPS2003, and keep getting an error when running the following stsadm command:

    stsadm -o restoressp -title Restored_SSP -url http://mosskurs2007:11111 -ssplogin MOSSKURS2007administrator -mysiteurl http://mosskurs2007/mysites -indexserver MOSSKURS2007 -indexlocation "c:index” -keepindex -sspdatabaseserver MOSSKURS2007 -sspdatabasename Laerdal1_PROF_OLD -ssppassword passord

    The error I keep getting is this:

    "The following required arguments are missing: sspdatabase

    Any idea what this might mean? I’ve tried supplying this argument, but the same error keeps coming up.

    Thanks, Frank

  2. jingmeili says:

    sspdatabase is not even a valid parameter for stsadm -o restoressp

    The only database related parameter is searchdatabasename, if you don’t pass a value for that it’ll just use the default name, something like SharedServices1_Search_DB

  3. frankok says:

    Thank you for your feedback.

    I know sspdatabase is not a valid parameter. When the error is displayed, so is the parameter list, and sspdatabase is not one of them.

    However, can you tell me if you see any of the other parameters are wrong, resulting in this error?

    Thank, Frank

  4. jingmeili says:


    I have never seen the error you described before and I don’t see any problems in your command. The url should be the SSP admin site and a subsite should have been created at http://mosskurs2007/mysites using My Site Host template. I *think* indexlocation needs to exist already.

  5. frankok says:

    Hi again.

    I found out the error. I downloaded the stsadm windows gui tool for MOSS 2007( and ran the command from there.

    I saw in the composed command that all parameters were quoted ("…").

    Thank you for you help.

  6. sanlaan says:

    Hey Jingmei

    Both this post and Baer’s reference the stsadm -o addcontentdb approach. How would one approach this using the gradual upgrade method? How would the steps differ?


  7. jingmeili says:


    Personally I haven’t done a gradual upgrade but I don’t think you need to execute command line like stsadm -o addcontentdb.

    Check with Bill Baer if you need more help with gradual upgrade.

  8. eniky says:

    Hi Jingmeili:

      after migrate my sites to Moss 2007, I can’t see any "My alerts" but "My links" is fine. How is this normally done.?

    thank you

  9. jingmeili says:


    Check this out about the alert not migrated…


  10. rajashekhark says:


    I am attempting to migrate my existing SSP (in which users have creates their MySites)  to a new farm. I have followed the steps mentioned in the article and I can see that all the user profiles are migrated successfully, I can also see the /personal/{uid}/ in the personal site attribute of the user profiles. However when I login to the site and click on the MySite, it tries to create the MySite for the user and fails with an error "Personal site cannot be created for the user, a site already exists, contact your administrator".

    Any help is appreciated.

    Thanks in advance


  11. jingmeili says:


    The scenario I described in this post has 1 web app to co-host both the portal and my sites. Double check your my site web app location and make sure it’s pointing to the same web app.

  12. ASMariner says:

    My question is how to migrate SPS 2003 My Sites to MOSS 2007 using a different web app(not the same web app hosting the Portal site)?

    Since it is recommended by Microsoft to deploy my sites to a seperate web app for medium to large deployment.


  13. jingmeili says:


    One approach you could try is to move the SPS 2003 My Sites into a separate content database if that’s not the case already, then in MOSS 2007, you just create a separate web app and attach the content db that contains the 2003 My Sites to it to upgrade.

    You could host them in the same web app initially for the migration and once they are over in MOSS 2007, you can migrate the My Sites into a separate Web App using stsadm commands (backup/restore or export/import).

  14. ASMariner says:

    I tried the backup/restore approach, but it seems that the personal sites on the new web app are not working, only see empty sites. Could you elaborate a little bit more on that?

  15. ASMariner says:

    Will the backup of the MySites from the migrated MOSS web sites have all the data needed for the MySites on the new Web App dedicated for the MySites?