Translate

Saturday, September 7, 2013

SharePoint 2013 Databases


Sharepoint 2013 databases


SharePoint 2013 has lot of improvements over SharePoint 2010.SharePoint 2013 has the following database.

The table illustrate the databases used in SharePoint 2013



Database
Description
Application Classification or Apps used By
App License
Stores the App licenses and permissions
downloaded from the global marketplace.
App Management
Conguration Database
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 speci c to
SharePoint 2013 Preview, such as default
quota and blocked le types.
Core Databases
Central
Administration Content
Content database for the Central
Administration site.
Central
Administration Content
Content
Databases
Stores all site content, including site
documents or les in document libraries,
list data, web part properties, audit logs,
sandboxed solutions, and usernames
and rights. All the data for a specic site
resides in one content database. Content
databases can contain more than one site
collection. Also stores data for Office Web
Applications, if in use.

Machine
Translation
Services
Stores information about pending and
completed batch document translations
with le extensions that are enabled.
Machine
Translation Services
Managed
Metadata Service
Stores managed meta data and
syndicated content types.
Managed
Metadata Service
PerformancePoint
Stores temporary objects and persisted
user comments and settings.

PowerPivot
Stores data refresh schedules and
PowerPivot usage data copied from the
central usage data collection database.
PowerPivot for SharePoint 2013 requires
SQL Server 2012 Analysis Services,
Business Intelligence, or Enterprise
Edition.

Project Server
Stores all the data for a single Project
Web App (PWA), along with the following:
All Project and Portfolio Management
(PPM) data
Time tracking and Timesheet data
Aggregated SharePoint project site data

Search
Hosts the Search application
con guration and access control list (ACL)
for the crawl component.
Search
Administration
Secure Store
Stores and maps credentials such as
account names and passwords.
Secure Store
Subscription
Settings Service
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.

State Service
Stores temporary state information for
InfoPath Forms Services, Exchange, the
chart web part, and Visio Services.

Usage and Health
Stores health monitoring and usage data
temporarily, and also used for reporting
and diagnostics. The Usage database is
the only SharePoint database that can
be queried directly and have schema
modi ed by either Microsoft or third-party
applications.
Usage and
Health
Database
User Pro les

Stores and manages users and their
social information.
Word Conversion
Stores information about pending and
completed document conversions.

Word Automation
Stores information about pending and
completed document conversions.

No comments:

Post a Comment