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

Files from my install (your GUIDs will vary)

   

  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
  

.