SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 5 sc in 1 database (Database1). (Databases have been created for each sc). Now the task is to move 4 of the sc database from Database1 and put them into different database (where they belong). Is there any good powershell or STS commands for this?

Thanks LA

share|improve this question
Which version pf Sharepoint, 2010 or 2007? – Colin Jun 21 '11 at 16:51
if you are satisfied with an answer, please mark it as answer or upvote answer. – Anders Rask Jun 21 '11 at 17:31

For SharePoint 2007 (STSADM - Preferred):

For SharePoint 2010 (Powershell Preferred):

share|improve this answer
@Thanks Ashish for your input as well. – lu A Jun 21 '11 at 17:07

The PowerShell command you are looking for is:

Move-SPSite <http://ServerName/Sites/SiteName> -DestinationDatabase <DestinationContentDb>

More information on Technet.

The stsadm alternative (or the only option if you are using WSS3 or MOSS) is stsadm -o mergecontentdbs, which is also documented on Technet.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.