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

 

 

New GDPR Analysis Pricing699<p class="lead">​​​Fuse can ease the challenge you are facing with the GDPR by offering a solution that will analyse your data for you quickly and cost effectively.</p><div></div><p>​My <a href="/_layouts/15/FIXUPREDIRECT.ASPX?WebId=4fc45909-2b6d-48b9-bcf9-a446e9d472d6&amp;TermSetId=c98895cd-d37f-4406-9cff-5480b4f829b6&amp;TermId=2b6bb279-9fd6-44bf-b4e7-23100b1f156a">recent blogs​</a> have already mentioned the effect that GDPR is having on UK businesses. The deadline is looming but <strong>don’t panic</strong> if you feel you are running out of time as we have <strong>important news</strong>. </p><p>Our customers are reporting that they are having many calls in response to the GDPR, offering you solutions to help but what you really need is a quick, fixed price solution that you know will do what it claims to. One of our partners has responded to customer and partner feedback by changing their pricing model for their data evaluation kit to be just that. </p><p>This is in response to listening to customers who have allocated budgets for the GDPR project, and it’s amazing to see that most budgets are being spent on the staff time spent on the project and not on solutions that would be more cost effective. Discovering PII (Personal Identifiable Information) is viewed as a <strong>manual process </strong>which costs organisations time and money. </p><p>Discovering personal Identifiable Information and Sensitive Information within documents is one of the first steps you need to complete to become compliant. </p><p>All you need is the answer to one question&#58;</p><p> <strong>Do you know the amount of data your business holds as electronic documents?</strong> Hopefully you do! If not, don’t worry we can help you find out with a <strong>free evaluation </strong>of your data.</p><div>If so, look at the table below for the cost of the solution we can introduce you to. The price includes an annual subscription with unlimited document scans for the 12-month license term, regardless of the size of documents.</div><div></div><ul><li>Up to 1TB = £2,999</li><li>Up to 5TB = £7,999</li><li>Up to 20TB = £14,999</li><li>20TB plus = price on application </li></ul><div>The pricing is based on the size of data in the system where the documents are stored. This pricing includes unlimited users and full product support. This solution can be used across multiple systems which include <strong> <em>Office 365</em></strong>, <strong> <em>Dropbox</em></strong>, <strong> <em>OneDrive</em></strong>, <strong> <em>Google Drive</em></strong> and <strong> <em>SharePoint</em></strong>. The solution then reads Office documents, PDF’s, OCR photocopies etc. It will also reduce the size of your files, removing duplicates and archiving&#160;<span style="text-align&#58;left;color&#58;#302e2f;text-transform&#58;none;text-indent&#58;0px;letter-spacing&#58;normal;font-family&#58;&quot;segoe ui&quot;,tahoma,helvetica,arial,verdana,sans-serif;font-size&#58;14px;font-style&#58;normal;font-variant&#58;normal;font-weight&#58;400;text-decoration&#58;none;word-spacing&#58;0px;display&#58;inline;white-space&#58;normal;orphans&#58;2;float&#58;none;background-color&#58;transparent;">files</span> non-accessed over a period. This solution is also valuable when <strong>migrating </strong>documents from SharePoint and file shares to O365.</div><div>&#160;</div><div class="thumbnail"> <img class="img-responsive" alt="ScanR Process" src="/ourblog/Blog%20Site%20Images/ScanRProcess.png" />&#160;</div><div></div><div class="well well-lg"><h2>Features of the ScanR Solution&#58;</h2><ul class="lead"><li>​Automate the process for discovering PII and Sensitive Information.</li><li>Enable you to quickly respond to “Subject Access Requests “and the “Right to be Forgotten “regulation.</li><li>Comply with over 10 of the required articles within GDPR.</li><li>Reduce data storage requirements, remove duplicates and archive non-accessed files. </li><li>Gain an understanding of who has access to it.</li><li>Gain an understanding of how long it’s being retained.</li><li>Retain personal data for a period of time directly related to the original intended purpose.</li><li>Find risky files and take action.</li><li>Manage a Subject Access Request&#58;</li><ul><li>Request a port of the data</li><li>Request a correction to the data</li><li>Request deletion of the data​</li></ul></ul></div><p></p><div class="thumbnail"> <img class="img-responsive" alt="ScanR overview" src="/ourblog/Blog%20Site%20Images/dashboard-scanr1.png" /> <div class="caption"><h3>The Overview Dashboard</h3><p>Rich dashboards in ScanR allow you to understand where your sensitive data resides, and prioritise where to take action.​</p></div></div><p>To read my previous blogs surrounding GDPR please click on the links below&#58; </p><p><a href="/_layouts/15/FIXUPREDIRECT.ASPX?WebId=4fc45909-2b6d-48b9-bcf9-a446e9d472d6&amp;TermSetId=c98895cd-d37f-4406-9cff-5480b4f829b6&amp;TermId=2b6bb279-9fd6-44bf-b4e7-23100b1f156a"><img class="ms-asset-icon ms-rtePosition-4" src="/_layouts/images/icgen.gif" alt="" />How to use SaaS solutions to identify sensitive data</a></p><p>​<a href="/_layouts/15/FIXUPREDIRECT.ASPX?WebId=4fc45909-2b6d-48b9-bcf9-a446e9d472d6&amp;TermSetId=c98895cd-d37f-4406-9cff-5480b4f829b6&amp;TermId=38ff9d3b-d9e1-4a22-b57e-04260d2d12b3"><img class="ms-asset-icon ms-rtePosition-4" src="/_layouts/images/icgen.gif" alt="" />Clear out the ROT!​</a></p><div class="well well-lg"> <p class="lead">To <strong>request a demo and free evaluation</strong> on your documents call Fuse today on 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">contact us</a>. We are available to answer any queries you have and our aim is to work alongside your needs and priorities ensuring optimum efficiency of your IT infrastructure.</p></div>l.ozier@fusecollaboration.com | Louise Ozier | 693A30232E777C6675736563735C6C2E6F7A696572 i:0#.w|fusecs\l.ozier22/11/2017 00:00:002017-11-22T00:00:00ZDiscover Personal Identifiable Information & Sensitive information within Documents24/11/2017 23:55:4096htmlFalseaspx

 Contact us

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