Sunday, October 27, 2013

SharePoint Server 2013 databases

In this post we will discuss about SharePoint server 2013 databases in SharePoint 2013 deployments. In my last post we discussed about various databases which are presented in both SharePoint Foundation 2013 and SharePoint Server 2013 deployments.

Also you can check out my previous posts on:

- Change default error and successful message in infopath 2013

- HTML Field Security option in SharePoint 2013

- Difference between Apps and Solutions in SharePoint 2013

- SharePoint User Profile service application databases:

The User Profile service has three databases that support SharePoint Server 2013.
1- Profile: It stores and manages users and associated information.

Default Database Name: User Profile Service Application_ProfileDB_<GUID>

2- Synchronization: This stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.

Default Database Name: User Profile Service Application_SyncDB_<GUID>

3- Social Tagging: The Social Tagging database stores social tags and notes created by users, alongside their respective URLs.

Default Database Name: User Profile Service Application_SocialDB_<GUID>

- Word Automation Services service application database:

This database stores information about pending and completed document conversions and updates.

Default Database Name: WordAutomationServices_<GUID>

- Managed Metadata Service service application database:

The Managed Metadata service application database stores managed metadata and syndicated content types.

Default Database Name: Managed Metadata Service Application_Metadata_<GUID>

- SharePoint Translation Services service application database:

The Machine Translation Services stores information about pending and completed batch document translations with file extensions that are enabled.

Default Database Name: SharePoint Translation Services_<GUID>

- Project Server service application database:

Project Server database contains data about All Project and Portfolio Management (PPM) data, Time tracking and Timesheet data and Aggregated SharePoint project site data.

Default Database Name: ProjectWebApp

- PerformancePoint Services service application database

The PerformancePoint Services database stores temporary objects and persisted user comments and settings.

Default Database Name: PerformancePoint Service _<GUID>

- State Service service application database

It stores temporary state information for InfoPath Forms Services, Exchange Server, the chart Web Part, and Visio Services.

Default Database Name: SessionStateService_<GUID>

More information you can get in technet article.

Twitter Delicious Facebook Digg Favorites More