Win prizes like Hard Disk, Pen drives, T-Shirts etc.
for more information
SharePoint Articles ↓
SharePoint Object Model
MasterPage & Page Layout
List & Library
View All Jobs
See All News
.Net Articles ↓
Testing (QTP) Training
Request a Quote
SharePoint 2013 databases
05-Jun-2013 8:15 PM
In this post we will discuss about what are the databases in SharePoint 2013. SharePoint 2013 uses more databases to improve the performance your SharePoint server farm.
You can also check out my previous posts on:
Enable Sign in as Different User Option in SharePoint 2013
Architectural changes in SharePoint 2013
Get column names of SharePoint list using SharePoint 2010 client object model
Stores the App licenses and permissions.
Stores External Content types and Related objects.
Contains data about all SharePoint databases, all Internet Information Services (IIS) websites or Web applications, trusted solutions, Web Part Packages, site templates, and Web application and farm settings specific to SharePoint 2013
Central Administration Content:
Content database for the Central Administration site. (SharePoint_Admin_Content)
Stores all site content, including site documents or files in document libraries, list data, web part properties, audit logs, sandboxed solutions, and usernames and rights. All the data for a specific site resides in one content database. Content databases can contain more than one site collection.
Search Administration (Search_Service_Application_DB_<GUID>):
Hosts the Search application configuration and access control list (ACL) for the crawl component.
Stores and maps credentials such as account names and passwords.
Usage and Health Database:
Stores health monitoring and usage data temporarily, and also used for reporting and diagnostics.
Profile (User Profile Service Application_ProfileDB_<GUID>):
Stores and manages users and their social information.
Synchronization (User Profile Service Application_SyncDB_<GUID>):
Stores confi guration and staging data for use when profile data is synchronized with directory services such as Active Directory.
Social Tagging (User Profile Service Application_SocialDB_<GUID>):
Stores social tags and notes created by users along with their respective URLs.
Stores features and settings information for hosted customers. This database is not created by default but must be created by using Windows PowerShell or SQL Server.
Word Automation Services database (WordAutomationServices_<GUID>):
Stores information about pending and completed document conversions.
Managed Metadata Service (Managed Metadata Service Application_Metadata_<GUID>):
Stores managed meta data and syndicated content types.
Machine Translation Services database (SharePoint Translation Services_<GUID>):
Stores information about pending and completed batch document translations with file extensions that are enabled.
Project Server database (ProjectWebApp):
Stores all the data for a single Project Web App (PWA).
PowerPivot database (DefaultPowerPivotServiceApplicationDB_<GUID>):
Stores data refresh schedules and
PowerPivot usage data copied from the central usage data collection database.
PerformancePoint Services database (PerformancePoint Service _<GUID>):
Stores temporary objects and persisted
user comments and settings.
State Service database (SessionStateService_<GUID>):
Stores temporary state information for InfoPath Forms Services, Exchange, the chart web part, and Visio Services.
Check out the full in this
If You Like this Post, Please Like us in Facebook and Follow us in Twitter
Share This Now >>
I am Bijay from Odisha, India. Currently working with a reputed organization in Bangalore. I am Microsoft Office Servers and Services (SharePoint) MVP (3 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out
My MVP Profile.
view full profile
To insert images, Upload images
or you can use flickr or picasa to upload images. After that paste the image url in the editor image dialog box.
Recent SharePoint Articles
-Enable Save as Template option Publishing Site SharePoint On...
-Disable list or libraries to appear in search result SharePo...
-Switch the default experience for list and libraries from ne...
-Switch the default experience for site from new or classic S...
-The required version of SharePoint Foundation or SharePoint ...
-SharePoint 2016 Develop and deploy custom feature using Visu...
See all articles
SharePoint Tag Cloud
AngularJS SharePoint (3)
Backup and Restore (13)
Business Conectivity Services (10)
CAML and LINQ (10)
Central Administration (3)
Excel Services (14)
Featurs and Event Receivers (18)
Interview Questions (11)
List and Library (122)
MasterPage and PageLayOut (22)
Moss 2007 (3)
Product Reviews (35)
REST API SharePoint (36)
SharePoint 2010 (96)
SharePoint 2013 (161)
SharePoint 2016 (43)
SharePoint 3rd party tools (2)
SharePoint Apps (45)
Sharepoint Customization (83)
SharePoint Designer (35)
SharePoint Object Model (75)
SharePoint Online and Office 365 (80)
SharePoint Search (34)
SharePoint Security (25)
Site Collection and Web Application (16)
Site Definition and Templates (14)
Video Tutorials (3)
Visual Studio (33)
WCF and Web Service (8)
Windows Azure (12)
Related SharePoint Articles
-Get Information Rights Management for entire farm using PowerShell Scripts
-SharePoint 2013 InfoPath Submit option multiple click issue
-We could not refresh the table resources from connection odata resources data
-SharePoint 2013 default permission levels
-Components of SharePoint designer workflow
-An error occurred when loading the Model event viewer error
See all articles
Recent Article Comments
14-Oct-2016 11:11 AM
Lotus Notes file converter helps you to recover NSF file and lotus notes fi...
13-Oct-2016 10:00 AM
Hi Sankar,May i know this formula is working when you are giving a differen...
29-Sep-2016 7:58 AM
I'm very big fan of you and i learnt many SharePoint concepts from your art...
29-Aug-2016 11:17 AM
Easily migrate from Lotus Notes to Outlook. The software converts Lotus Not...
29-Aug-2016 11:04 AM
Can easily recover corrupt MDF file and database file. This software can ea...
See all article comments
Subscribe by e-mail address to receive latest news and updates.