SharePoint 2010: Move a Site Collection to a Different Content Database

I had recently ran into a case where a site collection was not created in the correct content database. Moving it to the correct database is very simple.

SOLUTION

1) Open the SharePoint 2010 Management Shell as the SharePoint Farm Administrator
2) Enter the following command

Move-SPSite sitecollectionurl -DestinationDatabase contentdatabase

3) When prompted to confirm the move, type “Y”
4) Perform a reset of IIS using the iisreset command

You can now verify it was moved by viewing the site collections in the Central Administration site.

Advertisements
This entry was posted in SharePoint 2010, SQL Server 2008 R2 and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s