SharePoint 2010: SharePoint Foundation Databases

 

The following is a list of databases installed in a “Basic” install of SharePoint Foundation 2010.

 

Notes:

• SQL Server Express 2008 Service Pack 1 was installed
  

   Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
       Mar 29 2009 10:11:52
       Copyright (c) 1988-2008 Microsoft Corporation
       Express Edition (64-bit) on
        Windows NT 6.1 <X64> (Build 7600: ) (VM)

• If you want to install the SQL Express Management Tools:
• remember to download the 64 bit version
• check out this article or you won’t guess the correct choice (New Installation, not Add new features) http://www.asql.biz/Articoli/SQLX08/Art3_1.aspx
• the SQL Profiler is not part of the Express tools
  
• A new instance was created named SHAREPOINT  (yourservername.SHAREPOINT). The instance was created in
  C:\Program Files\Microsoft SQL Server\MSSQL10.SHAREPOINT
  
• The databases were created in:
  C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Data\MSSQL10.SHAREPOINT\MSSQL\DATA
  

Database Names:

• The “system” databases are named with GUIDs. We used to avoid this, or rename these, but it’s probably best to now leave these alone.
  In SharePoint Foundation these include:
• Bdc_Service_DB_guid   -  Business Connectivity Services (BCS)  (the old BDC)
• SharePoint_AdminContent_guid  - Central Administration
• SharePoint_Config_guid – the SharePoint Configuration database
  
• The content databases follow the 2007 pattern: WSS_Content or what ever you enter when you create a new application. (and I thought the “WSS” name was gone!)
  
• WSS_Search_yourservername – The WSS search database
  
• The new logging database! WSS_Logging. Think of this one as the one SharePoint database you are supposed to do direct TSQL queries from! As a teaser… here’s a list of the views (I’d show the tables, but each has 32 partitions):
                                                

Files from my install (your GUIDs will vary)

      

  Databases and log files:

• Bdc_Service_DB_778ccd3e047d45c1b71529c004ebbd2c.mdf
  Bdc_Service_DB_778ccd3e047d45c1b71529c004ebbd2c_log.LDF
  
• SharePoint_AdminContent_4ab2813a-fe77-4085-86df-41d3a79df116.mdf
  SharePoint_AdminContent_4ab2813a-fe77-4085-86df-41d3a79df116_log.LDF
  
• SharePoint_Config_e5403261-4d7a-4b9e-bef2-286c46b588da.mdf
  SharePoint_Config_e5403261-4d7a-4b9e-bef2-286c46b588da_log.LDF
  
• WSS_Content.mdf
  WSS_Content_log.LDF
  
• WSS_Logging.mdf
  WSS_Logging_log.LDF
  
• WSS_Search_MAXSP2010BETA2.mdf
  WSS_Search_MAXSP2010BETA2_log.LDF

 

  There are also the standard SQL Server databases there:

• master.mdf
• mastlog.ldf
• model.mdf
• modellog.ldf
• MSDBData.mdf
• MSDBLog.ldf
• tempdb.mdf
• templog.ldf

 

  And this file:

• MS_AgentSigningCertificate.cer