Skip Ribbon Commands
Skip to main content

Moving Existing MySites to a new application

 

Andrew Walman

30/06/2009

Many MOSS installations, particularly those that have grown over time or have been upgraded from SharePoint 2003, will have their mysite collection within another application, typically the intranet/portal. As the portal has matured, it becomes necessary to move the personal sites into their own application, within their own content database(s). We faced this situation ourselves, so here's how we did it:
 
First of all, what we had to start with was a structure left over from SharePoint 2003, as follows:
 
1 content database: SharePoint1_site
1 application: sharepoint
2 site collections: http://sharepoint (collaboration portal); http://sharepoint/personal/ (My site location)
 
The structure we want to achieve is:
 
New content database for the mysites: WSS_Content_InternalMySites (using the new naming convention)
Mysites hosted on their own application, in a new site collection: http://mysite/
 
With the portal remaining as is, all existing mysites migrated to the new application/database, and any new mysites created under the new application in the new database.
 
The steps we followed were:
  1. Ensure we have a full farm backup in Data Protection Manager
  2. Use stsadm enumsites with an xml out file to get a list of the sites within the existing database. stsadm -o enumsites -url http://sharepoint -databasename sharepoint1_site > Mysites.xml
  3. Edit this xml file so that only the personal sites are listed, save the file
  4. Add a new content database called "WSS_Content_InternalMysites" to the existing http://sharepoint application
  5. Run stsadm mergecontentdbs, injecting the list of sites and specifying the source and destination databases: stsadm –o mergecontentdbs –url http://sharepoint –sourcedatabasename sharepoint1_SITE -destinationdatabasename WSS_Content_InternalMySites –operation 3 –filename MySites.xml
  6. At this point, we have the sites split between the two databases - this is a useful operation to know as it is, and can help you arrange site collections that have "outgrown" one database into a new one (100GB is a good size for each content DB)
  7. Create a new application for the mysites - this will create a new content DB. It doesn't matter what this is called, as it will be removed soon. Reset IIS.
  8. Remove the WSS_Content_InternalMysites from the list of content DBs in the original application, and add it to the list in the mysites application. Remove the empty content database that was created as part of the application creation process.
  9. Create a mysite site collection in the new application, so that new mysites are created using the correct template
  10. To ensure all the original paths work in the migrated sites, we created a new managed path with explicit inclusion for "mysite". This may vary for other migrations, and may not be necessary at all.
  11. Update the SSP to point at the new application. One more IISReset for luck.
  12. Log in to the "system" account mysite - this will prompt you to update the default mysite location.
  13. Login as one of the users with a migrated mysite - you should see the original content. Also try a new user to make sure new mysites are created.
  14. Refresh DPM so that it picks up the new database and backs it up as part of the farm.
  15. Done.

Couple of caveats:

  • Don't use this for site collections with a size over 10GB (the enumsites operation gives you the size of each size collection within the database). You can use batch site manager to move site collections between 10 and 15GB, as this uses backup/restore instead of mergecontentdbs. For mysites, these limitations shouldn't apply, but if your are using this method for other site collections, they may well do.
  • Always do this out of hours, when database and WFE resources are free.
  • You may want to lock your site collections before the move, and quiesce the farm.
  • Don't cancel the operation - you'll corrupt both databases (but as you've made sure you've got a valid backup in step 1, this won't matter, right? ;) )

 About us

Fuse Collaboration Services is a Cloud Solution Provider and Microsoft Gold Partner specialising in delivering SharePoint, Skype for Business, and Azure cloud-based solutions. Based in Northampton, UK.

Microsoft Gold Partner Logo showing 5 competencies

Read more

 Latest Tweets

 Latest Blog

 

 

Better Mobile 4G and the Portable Office3089<p class="lead">​​<img class="img-responsive float-right" src="/ourblog/Blog%20Site%20Images/OneDrive-for-Business-App.png" alt="OneDrive for Business App" style="max-width&#58;300px;margin&#58;5px;" />Transport for London’s (TfL) plans to roll out 4G across the London Undergound network are continuing apace, with the <a href="http&#58;//www.cityam.com/287267/tfl-moves-step-closer-offering-4g-mobile-coverage-tube-2019" target="_blank">recent news</a> that this will likely include the new Elizabeth Line (aka CrossRail) and the planned C​rossRail 2 and Northern Line extension projects.</p><p>Suppliers and interested parties have had until July 6th to submit a selection questionnaire, which will then be evaluated before a more thorough tender goes out in early August.</p><p>City AM reports that companies will be competing to construct a commercial fibre optic network and the provision of a public WiFi service in specified TfL stations. The plan Is for the first stations to get connected during 2019, taking the capital one step closer to being a fully mobile working environment.​</p><p>WiFi already exists in some Tube stations, as it does on large parts of the train network across the country – even if the actual internet speeds vary widely depending on whereabouts you are!</p><p>Both TfL and the train companies will be heavily promoting the virtues of this type of connectivity for both leisure and work use, and it is popular here in the East Midlands, where we have a mixture of commuters heading into either London or Birmingham and companies who have to travel to see their clients.</p><p>But in the same way as nothing can beat the quality of a film that is already downloaded to your device, you need to make sure you have the processes and protocols in place for your mobile working to make sure you do not lose​ work unnecessarily. After all, there is nothing more frustrating than concentrating hard for an hour, only to see your work disappear because the saving process has not worked properly!</p><div class="well well-lg bg-color4 lead"><p>Here are Fuse’s top tips for your mobile working&#58;</p><ol><li>Make sure you have OneDrive syncing in place, so that when you save your document to your device it will automatically update onto your online OneDrive folder as soon as you are back online, thereby ensuring that your company work remains up-to-date<br></li><li>Do not get too reliant on having internet connectivity when you are on the move. Access to online resources may not be available for the duration of your whole journey, and even if your device is connected to the on-train WiFi the actual internet speeds will vary depending on whereabouts you are, or if you are in a tunnel<br></li><li>Have processes and checklists in place – even if they are just your own individual way of working, not official company policy – to ensure that you always download what you need onto your machine before you travel<br></li></ol></div>​ <p class="lead">Here at Fuse we believe that having the wherewithal to work effectively on the move is an integral part of the modern office. This includes OneDrive syncing being set up on all your machines, working with you to develop robust working practices for all your staff, and proactively making sure that your IT provision works to meet your needs, not the other way around.</p><div class="well well-lg"><p class="lead">Get in touch to find out how we can make sure that you have the great IT provision your organisation deserves! Call 01604 797979 or <a href="/_layouts/15/FIXUPREDIRECT.ASPX?WebId=4fc45909-2b6d-48b9-bcf9-a446e9d472d6&amp;TermSetId=c98895cd-d37f-4406-9cff-5480b4f829b6&amp;TermId=218eb0be-10f6-490a-82a7-a7fd47c8de90">send us an enquiry​​​</a></p>​ </div> | Chris Wearmouth | 693A30232E777C6675736563735C632E776561726D6F757468 i:0#.w|fusecs\c.wearmouth18/07/2018 23:00:002018-07-18T23:00:00ZAs better 4G rolls out across the nation how are you going to make your office truly mobile?As better 4G rolls out across the nation how are you going to make your office truly mobile?15/08/2018 09:36:021903htmlFalseaspx

 Contact us

Our address
12 Brookfield, Duncan Close
Moulton Park, Northampton
NN3 6WL
P: +44(0)1604 797979
Contact Us