Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be used for the same.
Move site collections to a new database or (split a content database)
a) At a command prompt on the drive where SharePoint Products and Technologies is installed, change to the following directory:
Mostly it is C: drive do
c:\program files\common files\Microsoft shared\Web server extensions\12\Bin
b)Type the following command, and then press ENTER:
Stsadm -o enumsites –url <URL> <path/file name>.xml
url: is the address of the Web application that contains the site collection that you want to move
path/file name: is the name of the XML file that you want to create with the site collection data.
The previous step creates an XML file that contains all of the site collection URLs in the current database.
c) Open the XML file that you created in step b. If there are also some other URLs for site collections which you do not want to move , delete them from the file.
URLs that you want to move should remain in the XML file.
Note: Nothing else in xml file need to be changed. Leave as it is..
d)Type the following command, and then press ENTER:
Stsadm -o mergecontentdbs –url <URL> -sourcedatabasename <database name> -destinationdatabasename <database name> -operation 3 –filename <file name>
Url: is the address of the Web application that have the site collection
sourcedatabasename: name of the database from which you want to move site collection
destinationdatabasename: name of the database in which you want to move the site collection
operation 3: “Read from file” operation
file name: name of the file that contains the site collection URLs.
e)Restart IIS by typing the following command, and then pressing ENTER:iisreset /noforce
Hope I was able to describe the content based on my knowledge and learning.
Feel free to Rate and provide feedback if you find post useful
Hope this help
Filed under: MOSS 2007, SQLServerPedia