Monday, January 17, 2011

Move SharePoint Site Collections between Content Databases

In SharePoint 2007 content databases can grow till 100 GB. What if you want to move your existing sites to a new content db?

Well, Here is the manual way to move site collection to a different database in SharePoint 2007:

  • Backup and Delete the Site Collection
  • Set all your Content Databases' maximum allowed sites to the number of current sites.
  • Set the Content Database you want the Site Collection to go into to allow one more Site Collection.
  • Restore the Site Collection
  • Adjust your Content Database maximums to allow new sites to be created. 
SharePoint 2007 move site collection to another content database - STSADM way:
You need to know your source DB, where your site resides first. How do we know what is the content db for a particular site collection? well, you can retrieve that information by running the stsadm command. Here is the command:
stsadm -o enumsites -url http://webapp_host_header > c:\sites.xml

Now, we've got and decided our source and destination DB's. ready to move the site? Here you go

stsadm -o mergecontentdbs -url http://web_App_URL -sourcedatabasename <Source DB Name> -destinationdatabasename <Destination_DB> -operation 3 -filename c:\output.xml

Move site collection to another content database in SharePoint 2010 / SharePoint 2013 using PowerShell:
Move site collection to another database in SharePoint 2010-2013, you can use the PowerShell cmdLet- Move-SpSite
Move-SPSite <URL of sharepoint site-collection> -DestinationDatabase <DB-Name>

Another nice way to move SharePoint Site collections between Content Databases: Use SharePoint Admin Tool kit - http://www.microsoft.com/downloads/details.aspx?familyid=BE58D769-2516-43CB-9890-3F79304528FF

It provides central Administration UI to move SharePoint site collection from one database to another


In case, you want to move the sites between Farms, You will have to backup/restore or export\import to move site collections.

Its always a good idea to take backup before doing these operations :-)

Technet article on mergecontentdbs: http://technet.microsoft.com/en-us/library/cc262923%28office.12%29.aspx



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

5 comments :

  1. This was extremely helpful! Thank you!

    ReplyDelete
  2. Really helpful!
    What if there is variation on your site collection?
    How can you copy / move to another site collection?
    Let's say from Production to Test?

    ReplyDelete
    Replies
    1. Since variations cannot be backup/restore by MOSS, Use this trick:
      1. Backup your site with: stsadm -o backup
      2. Create a New Site collection, create Variation labels as same as in your backed-up site or use Variation Editor: http://variationseditor.codeplex.com
      3. Restore the backup by overwrite the new site created: stsadm -o restore with "–overwrite" parameter.

      Delete
  3. Hi Salaudeen,
    This looks very useful but wondering if you can give me advice on my situation.
    I have a VERY LARGE site collection that has content database current size close to 450 GB. I have inherited this environment from another administrator who created all the sites within the same site collection and there are lots of sites with some of them 32 GB individual site size. I want to now move these large sites out of this one site collection to try and bring down the overall size to below 100 GB.
    How do you suggest I can do this. The performance of some of the sites is degrading due to this.
    Is there any proven way I can move individual sites to a new site collection? I am worried that if I use a powershell script or stsadm the export site commands might timeout due to the size of the sites and also worried about the import step.
    Any advice will be greatly appreciated.
    Thanks,
    Anant

    ReplyDelete
    Replies
    1. Anant,
      1. In my experience, I've successfully moved Site collections of 100 GB to new database with no issues with Move-SPSite.
      2. Always Take Database backups before doing such moves!

      Delete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...