Wednesday, September 9, 2015

Move site collection to another content database using PowerShell commands

We can move SharePoint site collection from one content DB to another Content database. But before moving the database we need to check following things,
·   New content database should be exists on the same server and it needs to be under the same web application.
·   The account used to move the site collection should be WSS_ADMIN_WPG group and account need to have db_owner permissions.
To move the site collection to the new content DB create a new content DB in SharePoint central Admin by navigating to Application management -> Manage Content Database -> Create new Content Database

Run following command in SharePoint management shell,

Move-SPSite SiteCollection URL -DestinationDatabase Target_Content_DB_Name
Example:

Move-SPSite 'http://xyz:1234/sites/accounting'  -DestinationDatabase wss_content_accounting            

This operation will take time depending on the site collection size. 

No comments:

Post a Comment