Databases Created during SharePoint 2010 Install

The databases that are automatically created when you run the SharePoint Products Configuration Wizard for SharePoint Server 2010, Standard Edition -

1. Secure Store database - The Secure Store service application database stores and maps credentials, such as account names and passwords. Prefixed with "Secure_Store_Service_DB_".

2. State database - The State service application database stores temporary state information for InfoPath Forms Services, the chart Web Part, and Visio Services. Prefixed with "StateService".

3. Web Analytics Staging database - The Staging database temporarily stores un-aggregated fact data, asset metadata, and queued batch data for the Web Analytics service application. Prefixed with "WebAnalyticsServiceApplication_StagingDB_"

4. Web Analytics Reporting database - The Reporting database stores aggregated standard report tables, fact data aggregated by groups of sites, date and asset metadata, and diagnostics information for the Web Analytics service application. Prefixed with "WebAnalyticsServiceApplication_ReportingDB_"

5. Search service application Administration database - The Administration database hosts the Search service application configuration and access control list (ACL), and best bets for the crawl component. This database is accessed for every user and administrative action. Prefixed with "Search_Service_Application_DB_".

6. Search service application Crawl database - The Crawl database stores the state of the crawled data and the crawl history. Prefixed with "Search_Service_Application_CrawlStoreDB_'.

7. Search service application Property database - The Property database stores information that is associated with the crawled data, including properties, history, and crawl queues. Prefixed with "Search_Service_Application_PropertyStoreDB_"

8. User Profile service application Profile database - The Profile database stores and manages users and associated information. It also stores information about a user's social network in addition to memberships in distribution lists and sites. Prefixed with "User Profile Service Application_ProfileDB_".

9. User Profile service application Synchronization database -The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.Prefixed with "User Profile Service Application_SyncDB_".

10. User Profile service application Social Tagging database - The Social Tagging database stores social tags and notes created by users, along with their respective URLs.Prefixed with "User Profile Service Application_SocialDB_".

11. Managed Metadata database - The Managed Metadata service application database stores managed metadata and syndicated content types. Prefixed with "
Managed Metadata Service_".

In addition to all the databases created with Standard edition, Enterprise addition install adds two more databases :

1. PerformancePoint service application database - The PerformancePoint service application database stores temporary objects, persisted filter values, and user comments. Name Prefix "PerformancePointServiceApplication_.."

2. Word Automation Services database - The Word Automation Services database stores information about pending and completed document conversions.Name Prefix "WordAutomationServices_..."

Note : You do not have to use these naming conventions. You can either specify database names when you create them, or change the database names after they have been created.


Post a Comment


This is a personal weblog. The opinions expressed here represent my own and not those of my employer or anyone else. Should you have any questions or concerns please e-mail me at .

Copyright (c) 2010 @ All rights are reserved.Do Not Copy.

@ Learning