Merge content databases (Search Server 2008)

  • Artikel

You can merge content databases when a database is smaller than expected and it is convenient to combine several site collections into one database to help with load balancing.

Merge content databases

Use the following procedure to merge content databases that are associated with your site collections.

Wichtig

Before you use the mergecontentdbs operation within the Stsadm command-line tool, 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 enumsites operation. For more information, see Enumsites: Stsadm-Vorgang (Office SharePoint Server).

Wichtig

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

Merge two or more site collection databases

  1. 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

  2. Type the following command, and then press ENTER:
    Stsadm -o mergecontentdbs -url <URL> -sourcedatabasename <database name> -destinationdatabasename <database name> -operation 2

    where url is the address of the Web application that contains the site collections that you want to move; sourcedatabasename is the name of the first database that you want to merge; destinationdatabasename is the name of the second database that you want to merge; and operation 2 is the “Full Database Merge” operation.

    For more information, see Mergecontentdbs: Stsadm-Vorgang (Office SharePoint Server).

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

Siehe auch

Konzepte

Add, split, and merge content databases (Search Server 2008)
Add a content database (Search Server 2008)
Move site collections to a new database (split a content database) (Search Server 2008)