Move site collections to a new database or || split a content database


Hey Friends,

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

where:
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

Ashi

About these ads
This entry was posted in MOSS 2007, SQLServerPedia. Bookmark the permalink.

5 Responses to Move site collections to a new database or || split a content database

  1. lista de email says:

    this is so beautiful i have to congratulate you for this.

  2. Nick says:

    Awesome trick and great thinking

  3. Mudassar Iqbal says:

    very nice trick…

  4. lista de emails says:

    the post is really very interesting and informative…

  5. Rahit says:

    I have been exploring for a little for any high-quality articles or blog posts in this kind
    of area . Exploring in Yahoo I ultimately stumbled upon this website.
    Studying this info So i am glad to convey that I have an incredibly excellent uncanny feeling I found out exactly what I needed.
    I most indubitably will make sure to dont disregard this website and give it a
    glance regularly.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s