Swap extended site collections RRS feed

  • Question

  • Hi, I am trying to swap the URLs of two extended site collections (with their own content database) in a web application.

    I know that there is no direct way of changing urls besides taking backup, delete the site collections and then restore. But my question is, how do I ensure that the extended site collections are created in their own separate databases as they were earlier.

    For the root level sites, if they are based off the same site definition, just changing the content databases should do the task. Is there a similar way to handle for extended site collections?


    Sashi Pagadala, SharePoint Practice Manager,
    Monday, September 5, 2011 5:46 PM

All replies

  • Hi,

    may be alternate access mappings in SharePoint could help you



    Hope this helps

    Bhushan | http://www.passionatetechie.blogspot.com | http://twitter.com/BhushanGawale
    Tuesday, September 6, 2011 4:22 AM
  • HI ,

    Follow this:

    1. First of all take full backup of your DBs and also take backups of your site collection.

    2. Now delete the site collections and detach thir respective content DBs from application.

    3. Now go to enlist the content databases of your web application under which you are going to create these site collections.

    4. Now take a screenshot for backup and in every content DB set the maximum number of sites equal to current number of sites.

    5. Then create a new DB with maximum number of sites as 1. Restore the backup of first site.

    6. Now follow above step again and then restore the second site as well.

    7. Now again refer the screenshot taken in step 3 and restore the number of sites.

    I hope this will help you out.

    Thanks, Rahul Rashu
    • Marked as answer by Pengyu Zhao Thursday, September 15, 2011 2:37 AM
    • Unmarked as answer by Pengyu Zhao Thursday, September 15, 2011 2:37 AM
    Wednesday, September 7, 2011 1:53 AM
  • There is an STSADM command to create site in New Database (-o Createsiteinnewdb ) available which was used to create the site and I have many such (100+) sitecollections under the root web application. If there was a way to remove the content database at a site collection level for the two sites and reassociate (Swap them) back, things would have been easy but unfortunately not so.

    I was wondering if this is possible through any coding or shell scripting?


    Sashi Pagadala, SharePoint Practice Manager,
    Wednesday, September 7, 2011 10:47 AM