TechBytes

Move Sites Across Content Databases in MOSS using STSADM Content Databases of web sites in MOSS can get reach their maximum storage limit at times. In a real world scenario there may arise a need to move a Site from one Content Database to another to accommodate the proper functioning and performance which can be directly dependent on the available storage limit of the Content Database. Hence it is always advised that you change the Sites Content database. The STSADM tool provides the functionality of performing this operation with ease. Steps: 1)At the Command Prompt use STSADM and Pipe the results into an XML file Example : stsadm -o enumsites -url http://MySite/ >c:\MySite.xml 2)Modify the ‘xml’ file to contain only the details of the ‘MySite’ 3)Move the ‘MySite’ from “WSS_Content_InfyDB” to new DB Example : stsadm -o mergecontentdbs -url http://MySite/ -sourcedatabasename WSS_Content_InfyDB -destinationdatabasename WSS_Content_NewInfyDB -operation 3 -filename c:\MySite.xml Succe