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.
1)At the Command Prompt use STSADM and Pipe the results into an XML file
Example : stsadm -o enumsites -url http://InfySite/ >c:\Infysite.xml
2)Modify the ‘xml’ file to contain only the details of the ‘InfySite’
Example : <Sites Count="3"><Site Url="http://InfySite1" Owner="ITLINFOSYS\InfyUser1" ContentDatabase="WSS_Content_InfyDB1" StorageUsedMB="0.2" StorageWarningMB="0" StorageMaxMB="0" />
<Site Url="http://InfySite2" Owner="ITLINFOSYS\InfyUser1" ContentDatabase="WSS_Content_InfyDB2" StorageUsedMB="0.4" StorageWarningMB="80" StorageMaxMB="100" />
<Site Url="http://InfySite" Owner="ITLINFOSYS\InfyUser1" ContentDatabase="WSS_Content_InfyDB" StorageUsedMB="99" StorageWarningMB="99" StorageMaxMB="100" />
</Sites>
After Modifying
<Sites Count="1">
<Site Url="http://InfySite" Owner="ITLINFOSYS\InfyUser1" ContentDatabase="WSS_Content_InfyDB" StorageUsedMB="99" StorageWarningMB="99" StorageMaxMB="100" />
</Sites>
3)Move the ‘InfySite’ from “WSS_Content_InfyDB” to new DB
Example :
stsadm -o mergecontentdbs -url http://InfySite/ -sourcedatabasename WSS_Content_InfyDB -destinationdatabasename WSS_Content_NewInfyDB -operation 3 -filename c:\Infysite.xml
Successful operation shows the following message on the command prompt.
http://InfySiteMoving sites...
Operation completed successfully.
IIS must be restarted before this change will take effect. To restart IIS, open
a command prompt window and type iisreset.
4)Do an IISReset
Go to Command Prompt -> Open Run à Type IISRESET
