.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Moving a site collection

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :SharePoint

I have a web application with site collections, each containing a single top-level site. I am trying to move a site collection from one content database to another programatically. I use SPExport and SPImport migration APIs. I do it in the follwoing way : 
Backup the site collection (SPExport)->Delete the Site->Create Site collection in another content database ->Restore(SPImport) .
But, I want to  have the approach as : Backup(SPExport)->CreateSite->Restore(SPImport)->DeleteSite. Basically, I want to do the restore before doing the deletion to mitigate the risk of being unable to restore/import the site after deleting the original site  But, the issue with this approach is that unless we delete a site we can't create a site with the same URL. I want to have the same URL. The site collections are path-based site collections. So we cant rename the site as in host-named site collections.
Any suggestion is appreciated.
The original requirement : A site collection with URL like {SPSite Url=http://mylab-dev.dom01.lab.dev/p/10000028} has to moved to another content database programatically, safely.



View Complete Post

More Related Resource Links

Moving a larger Sharepoint 2007 site collection over to a new server



We have a Sharepoint 2007 site collection roughly 36 GB in size and have been having problems moving the site to a new server farm (Also 2007). We are trying the Sharepoint backup and restore method, but I understand that this method is not recommended for sites over 5GB. Has anyone moved a site of this size and how did you do it?

Thanks  Ron


moving one site collection into a different site collection



I want to "merge" two site collections into one. So in effect I grab one and make it part of the other. I think the easiest way to do this might be with a backup/restore, but what will happen with the user groups and all the security settings? The groups of Site Collection A are not the same as the groups of Site Collection B. But I don't want to lose all the access permissions across either of the two site collections.

Is there a (easy) way of doing this?

Thanks for the help

trouble moving list to another site in collection


I am trying to use the process for moving a list to another site: http://blog.henryong.com/2008/01/21/how-to-movemigrate-sharepoint-list-itemsdocuments-and-preserve-metadata-properties-at-the-same-time/at-the-same-time .

I get this error:

An error was encountered performing this operation.


Operation to Move 'Remove scroller in lower right corner' to '/sites/itd/SBTD/Lists/Website Requests' Failed
No items were moved. Please remove Remove scroller in lower right corner from the selection and retry operation

Can anyone tell me what went wrong.  Could not find referece to this error.  What scroller are they talking about?

There are no mistakes; every result tells you something of value about what your are trying to accomplish.

Tried moving a site collection - it failed

Hi All,

I just downloaded and installed the SharePoint Administration Toolkit so that I could use the "Move" site collection feature.

It errors out with an "Access Denied" error. 

OK, but access to what - the database?  If so what permissions do I need?  I have them all I think.  I created the databases (both of them) and can add, change, delete, whatever I need to do.

Here is the exact error I got in the email.



Job Title: Research Wiki Move
Job Description:
Start Time: 8/27/2008 11:10:46 AM
http://info23:21270/sites/research -- Operation FAILED: Microsoft.SharePoint.SPException: An error occured in stsadm.exe while moving the site. Access denied.

   at Microsoft.Office.Server.ESCM.ESCMMoveJob.Backup(Uri Src)
   at Microsoft.Office.Server.ESCM.ESCMMoveJob.JobTaskExecute(String SiteUrl)
   at Microsoft.Office.Server.ESCM.ESCMJob.Execute(Guid targetInstanceId)
End Time: 8/27/2008 11:10:48 AM


Site Collection Usage Summary: No Data Available


Usage analysis processing is enable for my farm in both Central Administration and in the SSP.

I've checked TImer Job Status and the three timer jobs responsible for doing the log analsis are all running.

I've also checked the log file locations and the log files are being generated.

Yet when I browse the "Site collection usage summary" report (SpUsageSite.aspx) I get the following:

No data is available for this report. Usage analysis might have been enabled only recently, or there might have been insufficient usage to result in any values for the report.

My farm is running 2007 Enterprise SP2 (

Can someone confirm if this issue was fixed with one of the CU's that were issues post-SP2?

Site Collection Usage Report Include Outlook?


Hi all,

Does anyone know if the Site Collection Usage Report includes activity that occurs from Outlook? For example, if a user contributes to a discussion board without ever physically touching the site or if the user just reads list content from Outlook, is this included?

ANY help at all is greatly appreciated.


Portal Search Work - Site Collection Search Does Not


In our SharePoint installation we have an SSP which indexes local office sharepoint server sites.  However there is a problem, although we can do portal searches which reveal search results it is not able to do local searches at the site collection level and as a result we are presented with the typical error below.


No results matching your search were found.

  1. Check your spelling. Are the words in your query spelled correctly?
  2. Try using synonyms. Maybe what you're looking for uses slightly different words.
  3. Make your search more general. Try more general terms in place of specific ones.
  4. Try your search in a different scope. Different scopes can have different results.

I am unsure as to why this strange event is occuring.  We do not have the WSS Search component running in the MOSS environment as the SSP service should be able to index and server search queries at the portal and local site collection level.


Any thoughts to this?



Video: Site Collection Solution Galleries in SharePoint 2010

This demonstration shows the solution gallery and solution management features of SharePoint 2010. (Length: 4:01)

Only crawl one site collection

Hi We have an intranet with about 100 site collections. How can I set up one of those to be in a separate content source that can be crawled more often? Do I need to make two content sources with one containing the other 99 site collections with the setting "Crawl only the SharePoint Site of each start address" and the other one containg my prioritized site collection with the same setting? I also would like to ask if the crawl rules have any effect on in which order the content is crawled. If I put a certain site to be included with order 1 will that site always be crawled first? //Niclas

site collection size

what is the solution of a site collection if its size grows beyond 100GB?  There is no way we can split it into two site collections and the content database will be large than 100GB even if it contains a signal site collection. Thanks in advance, Peter  

SharePoint Search not working on one site collection

I am running into some weird behavior with how SharePoint is crawling site/list data.  Let's say our main intranet site is http://www.intranet.com: Most of our older sites are setup with URLs like http://www.intranet.com/sites/sitename .  Crawling is working fine on these sites and I can execute a search and find all of the results I would expect.  At some point recently (before I joined this firm), they made a decision that all new sites would have the URL http://www.intranet.com/SiteDirectory/sitename .  Any sites which fall into this bucket are not being crawled, it would seem. If I check Central Adman>Shared Services>Search Administration, I can see that the first content source being crawled is http://www.intranet.com so I would imagine this crawl should pick up anything under /SiteDirectory/ but it is not.  I also checked the Crawl Settings on this page and it is set to "Crawl everything under the hostname for each start address".  Lastly, I see that there were only 21 errors in the last full crawl but none of these errors apply to a /SiteDirectory/ site. In short, what could be causing the crawl to apparently skip all of the sites within /SiteDirectory/ and how can this best be fixed?

Custom Theme for entire Site Collection

I created a theme with custom css for sharepoint 2010 Is it possible for me to use my custom CSS and have it be a selectable theme from each site without me having to modify the master pages of each site that wants to use the theme?

All Users (Including Site Collection Admins) receiving Access Denied from one Site Collection

I usually spend my time in the forums answering questions.  But this time I need the help. I’ve got a client who somehow has succeeded in locking EVERYONE out of one of their Site Collections.  Users can authenticate to the site, but get an accessdenied page when you try to access anything in the site collection, including pages served from the _Layouts virtual directory.  The AccessDenied page shows that they are authenticated, but not authorized.  This is true for Site Collection admins and user’s who have been given Grant Full Control via a Web Application Permission Policy.  Central Admin and one other site collection are behaving normally.  I've already checked for database permissions - the service account can access the database fine. I've also checked for a locked database or overextended quota.  It's not that either. The accessdenied page url references the users list in the root of the site collection as the offending list denying access.   Does anyone have any ideas?Paul Stork SharePoint Server MVP

how do I make each site collection have its own separate FQDN URL?

Howdy. We've got SP2010 up and running just fine but now we'd like for each site collection to have its own FQDN URL that's publicly accessible. We've already bought a wildcard cert and have it answering on port 443. Example: https://intranet.example.com -> https://sp2010.example.com/sites/intranet https://projects.example.com -> https://sp2010.example.com/sites/projects https://my.example.com -> https://sp2010.example.com/my Again, each URL on the right already works but we'd like the FQDN on the left to map to the URL on the right. I searched this forum for "multiple site collections",  "multiple FQDNs" and a couple others but got nothing :( Thanks, -Jeff

Creating a new root Site Collection using a custom site definition file (ONET.XML)

Using Powershell, I am trying to deploy the our custom solution to SP 2010.  The script is doing the following: Deleting the web application using Remove-SPWebApplication Creating a new web application using New-SPWebApplication Adding and deploying a series of WSP files (one of which has the site definition file in it) using Add-SPSolution and Install-SPSolution Create a root site collection based on the site definition file provided in the WSPs using New-SPSite I get the error "WARNING: Template is not found and is not applied." When I run Get-SPWebTemplate, my site definition does not show up. I saw this: http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/5ea46e07-a4b0-4bab-b698-9b6eeb695607 but I want a solution that does not involve me reloading a DLL, as, I feel there is something else I am forgetting. I have also tried: IISReset Resetting the timer service Cleaning the Cache (as described here: http://support.microsoft.com/kb/939308) Nothing seems to work.  Does anyone have any ideas?

cannot create a site collection

hi all, When I was creating a site collection in a new created web application, after clicking 'OK', it skipped to a page with error information which is: Error The URL 'Reporting Templates/audit.xlsx' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 55bd00e8-3ecd-41bc-b534-e59fbebfc2b7 Date and Time: 8/31/2010 3:20:38 PM I never met this before, what's wrong with my farm?

how to display bread-crumb always starting from the root-web of the site collection, not the current

Hello all, In sharepoint 2010, the breadcrumb shown in the title area starts from the site you are currently into. Suppose my root web is Home and I have a subsite called Child1 and under this subsite I have another subsite called GrandChild1 My requirement : when I am at Home site .. currently the bread crumb shows Home .. as expected it shows Home when I am at Child1 site .. currently the bread crumb shows Child1 .. expecting it to be Home > Child1 when I am at Child1 site .. currently the bread crumb shows GrandChild1 .. expecting it to be Home > Child1 > GrandChild1   How can I achieve this ? Thanks mano   Mano Mangaldas | Blog : http://howtosharepoint.blogspot.com 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend