Sharepoint 2013 databases
SharePoint 2013 has lot of improvements over SharePoint
2010.SharePoint 2013 has the following database.
Database
|
Description
|
Application
Classification or Apps used By
|
App License
|
Stores the App licenses and permissions
downloaded from the global marketplace.
|
App Management
|
Configuration 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 specifi c to
SharePoint 2013 Preview, such as default
quota and blocked fi 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 fi les 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. Also stores data for Office Web
Applications, if in use.
|
|
Machine
Translation
Services
|
Stores information about pending and
completed batch document translations
with file 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
confi 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
modifi ed by either Microsoft or third-party
applications.
|
Usage and
Health
Database
|
User Profi 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