Export (0) Print
Expand All

Add or remove a property database

 

Applies to: SharePoint Server 2010

Topic Last Modified: 2010-05-13

In Microsoft SharePoint Server 2010 Search, property databases contain metadata associated with crawled content. You can distribute the database load of queries by adding property databases to different computers that are running SQL Server. Property databases are associated with index partitions, and return any metadata associated with content in query results. For more information about index partitions, see Add or remove an index partition.

  1. In Central Administration, in the Application Management section, click Manage service applications.

  2. On the Service Applications page, click the name of the Search Service Application to which you want to add a property database.

  3. On the Search Administration page, in the Search Application Topology section, click the Modify button.

    noteNote
    The SharePoint Search topology cannot be changed in Standalone installations.
  4. On the Manage Search Topology page, click New, and then click Property Database.

  5. In the Add Property Database dialog box, in the Add Property Database section, specify a database server to which you want to add the property database, the database name, and database authentication information. By default, the Database Server field contains the host name and instance that is used to store the farm’s configuration database, and the Database Name field is pre-populated with a suggested name.

  6. In the Failover Database Server field, you can optionally specify a failover database server that is used in conjunction with SQL Server database mirroring.

    importantImportant
    Do not enter a server name into this field unless SQL Server database mirroring is currently configured and operational.
  7. Click OK to add the new property database to the job queue.

  8. On the Manage Search Topology page, click the Apply Topology Changes button to start the SharePoint timer job that will add the new property database to the selected SQL Server computer and make it available for association with index partitions.

    noteNote
    You can make other changes to the Search topology and then apply them all at once by clicking the Apply Topology Changes button.

importantImportant
Before you can delete a property database, you must first remove any associations with any query components either by removing the query components or by assigning them to a different property database. If any query components are currently associated with the property database, the Delete option will not appear when you click the property database.
  1. In Central Administration, in the Application Management section, click Manage service applications.

  2. On the Service Applications page, click the name of the Search Service Application from which you want to remove a property database.

  3. On the Search Administration page, in the Search Application Topology section, click the Modify button.

    noteNote
    The SharePoint Search topology cannot be changed in Standalone installations.
  4. On the Manage Search Topology page, click the property database you want to remove, and then click Delete.

    noteNote
    If any query components are currently associated with the property database, the Delete option will not appear when you click the property database.
  5. In the message box that appears, click OK to add the removal of the property database to the job queue.

  6. On the Manage Search Topology page, click the Apply Topology Changes button to start the SharePoint timer job that will delete the property database from the specified computer that is running SQL Server and remove it from the farm.

    noteNote
    You can make other changes to the Search topology and then apply them all at once by clicking the Apply Topology Changes button.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft