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
Successful operation shows the following message on the command prompt.
http://MySiteMoving sites...Operation completed successfully.IIS must be restarted before this change will take effect. To restart IIS, opena command prompt window and type iisreset.
4)Do an IISReset
Go to Command Prompt -> Open Run and Type IISRESET

Comments

Popular posts from this blog

Better manage customer relationships using Outlook Customer Manager

Understanding the Cloud Spectrum

Multi-Factor Authentication for Office 365