11/30/2009

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):
                                                   image

Files from my install (your GUIDs will vary)

       image

  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

 

 

image

No comments:

Note to spammers!

Spammers, don't waste your time... all posts are moderated. If your comment includes unrelated links, is advertising, or just pure spam, it will never be seen.