Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
1  
if you are satisfied with an answer, please mark it as answer or upvote answer. –  Anders Rask Jun 21 '11 at 17:31

2 Answers 2

For SharePoint 2007 (STSADM - Preferred): http://technet.microsoft.com/en-us/library/cc825328(office.12).aspx

For SharePoint 2010 (Powershell Preferred): http://technet.microsoft.com/en-us/library/cc825328.aspx

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

 
discard

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.