Wednesday, October 29, 2008

Move site collections to a new database (split a content database) (Windows SharePoint Services 3.0)

Here is some information of doing WSS 3.0/MOSS 2007 content db management.

http://technet.microsoft.com/en-us/library/cc825327.aspx

i have also copied the content below just incase that link is not available.
=====================================================
Some site collections within a database that hosts multiple site collections are growing faster than expected, and you expect the database to approach its size limit quickly. You can split the database to move the growing site collections to another database or to another server.

Split a content database
You can use this procedure to split a content database that is associated with your site collections. The process of moving a site collection between databases consists of exporting the site collection URL data to a file and then importing the data to a new database.

Important:
Before you use the Stsadm mergecontentdbs operation, make sure that there is free space available on the hard disk that is equivalent to at least three times the size of the source site collection. To determine the size of your site collection, refer to the StorageUsedMB attribute of the Stsadm enumsites operation in step 2 of the following procedure.

Important:
The account used to restore the databases must be a member of the Administrators group on the local computer to complete the following procedure.


Split a content database (move a site collection to a different database)
At a command prompt on the drive where SharePoint Products and Technologies is installed, change to the following directory:

%COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin

Type the following command, and then press ENTER:
Stsadm -o enumsites -url > .xml

where url is the address of the Web application that contains the site collection that you want to move, and path/file name is the name of the XML file that you want to create with the site collection data.

For more information, see Enumsites: Stsadm operation (Windows SharePoint Services).

The previous step creates an XML file that contains all of the site collection URLs in the current database.

Open the XML file that you created in a text editing application. If there are any URLs for site collections that you do not want to move, be sure to delete them from the file. The only URLs that should remain in the XML file should be for the site collections that you want to move.

Note:
There is no need to change the site count or any of the other site collection information in the file. Only the URLs are relevant to this procedure.


Type the following command, and then press ENTER:
Stsadm -o mergecontentdbs -url -sourcedatabasename -destinationdatabasename -operation 3 -filename

where url is the address of the Web application that contains the site collection that you want; sourcedatabasename is the name of the database that you want to move the site collection from; destinationdatabasename is the name of the database that you want to move the site collection to; operation 3 is the “Read from file” operation; and file name is the name of the file that contains the site collection URLs that you want to move.

For more information, see Mergecontentdbs: Stsadm operation (Windows SharePoint Services).

Restart IIS by typing the following command, and then pressing ENTER:
iisreset /noforce

No comments: