Search code examples
sharepointsharepoint-2007

Where is (are) the SharePoint 2007 content database(s)?

The DBA's want to know which databases I'm supporting. I haven't found what database servers these are on. I have tried the following approaches:

  1. I have read that the default is the directory, C:\Program Files\MS SQL\Data, according to this blog Content Database – Changing Default Location. I didn't find an mdb file.
  2. I have looked in Sharepoint Central Administration > Application Management > Content Databases and found a content database name, but I couldn't find that in SharePoint's Central Configuration Web.config.
  3. If it's in the instance's Web.config, I haven't found it.

The DBA's think that I have a different database for each site, but I cannot confirm this. Thanks in advance for any direction you can give me.

Solution

  • The default location you are referring to is the default location for SQL databases.

    1. Go to Sharepoint Central Administration > Application Management > Content Databases

    2. Change the Web application (on the right hand side of the screen) to the site you are looking for

    3. Click on the Database Name

    4. This page should tell you the database name and the database server. Copy both the Database server and the SQL server database name.

    This should be the information the DBA's are looking for.

    At a minimum you will have a Database per Web Application, but you can also have more than one, depending on how your SharePoint environment has been configure. You will see how many content databases you have per site on the "Manage Content Databases" site from step 2.

    These steps show you the Content Databases, but SharePoint also uses additional databases for config and shared services. Hope this helps!

    UPDATE:

    • PROD_APPNAME_Search - I think this is your serach DB. To confirm go to Central Administration > Operations > Services on Server > Windows SharePoint Services Help Search

    • PROD_APPNAME_SharePoint_Config - Config DB for sharepoint. See this in the SharePoint Products and Technologies Configuration Wizard on the SharePoint server

    • PROD_APPNAME_SSP_DB - SSP Database (should be able to confirm this
      from the step below)

    • PROD_APPNAME_SSP_Search_DB - Search Database
      (should be able to confirm this from the step below)

    • PROD_APPNAME_SSP_WEB_APP - probably the content DB for the SSP
      (should be able to see this in the steps from my original reply)

    • PROD_APPNAME_WEB_APP - content DB? (should be able to see this in the steps from my original reply)

    • PROD_APPNAME_MY_SITES - content DB? (should be able to see this in the steps from my original reply)

    It looks like whoever setup your farm setup the DBs with the naming format PROD_APPNAME_, which is recommended.

    To see the SSP DB's go to http://[servername]/_admin/managessp.aspx. For each SSP (you will probably only have one) click edit properties.