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

 

 

Skype for Business and so much more…195<p class="lead"> Yes? Then this is an important read!</p><p>We all know (hopefully!) <a href="/_layouts/15/FIXUPREDIRECT.ASPX?WebId=4fc45909-2b6d-48b9-bcf9-a446e9d472d6&amp;TermSetId=c98895cd-d37f-4406-9cff-5480b4f829b6&amp;TermId=4cd8262c-9c67-4bcb-8f13-65e8ffa6299a">what Skype for Business is</a> but what is different about the version we can offer? </p><p>Fuse has been working ​with the UK's leading Skype for Business provider since they began operating four years ago. Working alongside our partners you will receive the usual unified communications inherent in Skype for Business but further to this you will have access to call centre solutions, call monitoring, call analytics and 24-hour support. The support is available globally and frees up IT staff allowing them to increase their productivity and availability. </p><p>Further to the above features you will have access to an online portal which will allow you to quickly commission and decommission users, configure/reconfigure call groups, manage users and telephone numbers, configure interactive voice response(IVR), call routing, on hold marketing and call reporting.</p><p>Working with the solution we offer, you will be given the benefit of not having a long-term contract tying you in to a lengthy subscription. You can down scale or upscale monthly, giving you the control of your budgets. The flexible scale up/down in line with organisational changes is an important bonus to many customers. </p><p>The monthly price works out at half the price of competitors with call bundles and next to no downtime. </p><p> <strong>The benefits are&#58;</strong></p><ul><li>Reduced annual costs as one monthly cost includes unlimited free outbound calls to UK and line telephone numbers. International call packages are available. Free calls to UK mobile numbers available as an add on</li><li>Flexible working - inbound and outbound business calls and online meetings from anywhere with an internet connection</li><li>Encrypted and secure communication<br></li><li>End to End Fully Managed Service</li><li>24 hr, 7 days a week dedicated support; online support and contact centre</li><li>Online Visual Management and Analytics Portal</li><li>Global solution, from reslient datacenters with multiple providers</li><li>Audio and video conference facility for up to 250 participants – even if they're not on Skype for Business. All they need is a phone or internet connection.</li><li>Fixed monthly fee per user that is payable on a monthly subscription</li><li>Integration with Outlook/SharePoint to show availability/presence (on premise or O365)</li><li>Increases productivity - Collaboration between teams is simplified due to the ability to share files etc.</li><li>Instant messaging with dancing emojis!</li></ul><hr />​​ <div class="well well-lg"><p class="lead">​To book a demo contact Fuse Collaboration on 01604 797979 or email fuse@fusecollaboration.com </p></div>​​ <p>Fuse Collaboration is a Microsoft accredited Gold Partner, License and Systems Specialist</p>​ ​l.ozier@fusecollaboration.com | Louise Ozier | 693A30232E777C6675736563735C6C2E6F7A696572 i:0#.w|fusecs\l.ozier26/06/2017 23:00:002017-06-26T23:00:00ZDoes your business make lots of phone calls?29/06/2017 15:18:4654https://www.fusecollaboration.com/ourblog/Pages/Forms/AllItems.aspxhtmlFalseaspx

 Contact us

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