Discover core databases for a Windows SharePoint Services 3.0 farm

Posted on March 4, 2010, under SharePoint.

Below are steps for one method to discover databases used by a WSS 3.0 farm. Log in to SharePoint Central Administration for each of these activities.

Configuration Database

  1. Go to the “Operations” tab
  2. Click “Servers in Farm”
  3. Under “Farm Information” see the following items:
    1. Configuration database server
    2. Configuration database name

Central Administration Content Database

  1. Go to the “Application Management” tab
  2. Click “Web application list”
  3. Click “SharePoint Central Administration v3″
  4. Under “SharePoint Site Management”, click “Site collection list”
  5. Under the root “/” site, look in the information table for the “Database Name” value

General Usage Content Databases

  1. Go to the “Application Management” tab
  2. Click “Web application list”
  3. For each web application listed other than “SharePoint Central Administration v3″ (see above), perform the following:
    1. Click the web application name
    2. Under “SharePoint Site Management”, click “Site collection list”
    3. For each listed site collection (by URL):
      1. Click the URL of the site collection
      2. In the information table, look for the “Database Name” value

Search Database

  1. Go to the “Operations” tab
  2. Under “Topology and Services”, click “Services on server”
  3. Click the text “Windows SharePoint Services Help Search”
  4. Under “Search Database”, look for the values:
    • Database Server
    • Database Name

Leave a Comment