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
-Get List with Lookup Column Powershell Script SharePoint 201...
-Extract termstores in SharePoint 2013 using PowerShell
-Display Power BI Report in SharePoint Online
-SQL BAK Recovery Tool To Repair Corrupt SQL Backup File
-SQL Server Physical File Fragmentation Complete Guide
-Killing a SPID in SQL Server and Checking Rollback Progress
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 (123)
MasterPage and PageLayOut (23)
Moss 2007 (3)
Product Reviews (37)
REST API SharePoint (36)
SharePoint 2010 (96)
SharePoint 2013 (161)
SharePoint 2016 (44)
SharePoint 3rd party tools (2)
SharePoint Apps (45)
Sharepoint Customization (83)
SharePoint Designer (35)
SharePoint Object Model (75)
SharePoint Online and Office 365 (83)
SharePoint Search (34)
SharePoint Security (25)
Site Collection and Web Application (16)
Site Definition and Templates (15)
Video Tutorials (3)
Visual Studio (33)
WCF and Web Service (8)
Windows Azure (19)
Related SharePoint Articles
-Remote Event Receiver Troubleshooting in SharePoint 2013
-The form cannot be submitted because of an error in SharePoint
-Cannot connect to database master at sql server sharepoint 2010
-SharePoint Server 2016 Beta 2 and SharePoint 2016 RC Single Server Farm Technical Preview Deployment Guide Part-2
-Adding Custom Ribbon Tab in the SharePoint 2013 Server Ribbon
-Customize Change quick launch style and design SharePoint
See all articles
Recent Article Comments
03-Nov-2016 7:48 AM
Great !!!I too faced this issue.This solution worked perfectly:) Thank...
02-Nov-2016 8:59 AM
SharePoint Recovery software is a solution to restore triggers, lists, docu...
26-Oct-2016 5:04 PM
Use third party OST to PST solution for recover OST file data and convert i...
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...
See all article comments
Subscribe by e-mail address to receive latest news and updates.