11/30/2009

SharePoint 2010: SharePoint Server Databases

 

 

The following is a list of databases installed in a “Basic” install of SharePoint Server 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\Microsoft Office Servers\14.0\Data\MSSQL10.SHAREPOINT\MSSQL\DATA
    (Foundation defaults to here: 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 2010 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
  • In SharePoint Server 2010 they add:
    • Application_Registry_Service_DB_guid
    • Managed Metadata Service_guid
    • PerformancePoint Service Application_guid
    • Search_Service_Application_CrawlStoreDB_guid
    • Search_Service_Application_DB_guid
    • Search_Service_Application_PropertyStoreDB_guid
    • Secure_Store_Service_DB_guid
    • StateService_guid
    • User Profile Service Application_ProfileDB_guid
    • User Profile Service Application_SocialDB_guid
    • User Profile Service Application_SyncDB_guid
    • WebAnalyticsServiceApplication_ReportingDB_guid
    • WebAnalyticsServiceApplication_StagingDB_guid
    • Word Automation Services_guid
  • 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 in SharePoint Foundation 2010:

  • 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

   Additional databases and log files in SharePoint Server 2010:

  • Application_Registry_Service_DB_b669b0a586ce4cfaa1020e9e75824843.mdf
    Application_Registry_Service_DB_b669b0a586ce4cfaa1020e9e75824843_log.LDF
  • Managed Metadata Service_6b696a9bda574b29a0bba4009c782316.mdf
    Managed Metadata Service_6b696a9bda574b29a0bba4009c782316_log.LDF
  • PerformancePoint Service Application_106ff2206d784297adbd4ec157aef7b5.mdf
    PerformancePoint Service Application_106ff2206d784297adbd4ec157aef7b5_log.LDF
  • Search_Service_Application_CrawlStoreDB_16d445d62e314cd58c82d75fc304a225.mdf
    Search_Service_Application_CrawlStoreDB_16d445d62e314cd58c82d75fc304a225_log.LDF
  • Search_Service_Application_DB_e172668d1a534fd981b53146014d5ef3.mdf
    Search_Service_Application_DB_e172668d1a534fd981b53146014d5ef3_log.LDF
  • Search_Service_Application_PropertyStoreDB_10c4d562200442748ca6339d4b358c84.mdf
    Search_Service_Application_PropertyStoreDB_10c4d562200442748ca6339d4b358c84_log.LDF
  • Secure_Store_Service_DB_edd7b8e261fa491bb336779301aa5bf9.mdf
    Secure_Store_Service_DB_edd7b8e261fa491bb336779301aa5bf9_log.LDF
  • StateService_335919bb65d1430aa20424a67a99589e.mdf
    StateService_335919bb65d1430aa20424a67a99589e_log.LDF
  • User Profile Service Application_ProfileDB_9e421f2d762c46609a8a15fab15a3d52.mdf
    User Profile Service Application_ProfileDB_9e421f2d762c46609a8a15fab15a3d52_log.LDF
  • User Profile Service Application_SocialDB_81269e32afd049d48994a72362806da4.mdf
    User Profile Service Application_SocialDB_81269e32afd049d48994a72362806da4_log.LDF
  • User Profile Service Application_SyncDB_8c10242fd8064682aa1ac620acfa1733.mdf
    User Profile Service Application_SyncDB_8c10242fd8064682aa1ac620acfa1733_log.LDF
  • WebAnalyticsServiceApplication_ReportingDB_1684bae4-0271-40f0-9e4d-84c6660e99e0.mdf
    WebAnalyticsServiceApplication_ReportingDB_1684bae4-0271-40f0-9e4d-84c6660e99e0_log.LDF
  • WebAnalyticsServiceApplication_StagingDB_13d64d79-9237-492c-ad2d-48785d13a1ff.mdf
    WebAnalyticsServiceApplication_StagingDB_13d64d79-9237-492c-ad2d-48785d13a1ff_log.LDF
  • Word Automation Services_5fd65b951cf1499eaa72997b9668fd04.mdf
    Word Automation Services_5fd65b951cf1499eaa72997b9668fd04_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

.

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.