Skip to main content

State Service Database

The State Service is a shared service that is used by some Microsoft SharePoint Server 2010 components to store temporary data across related HTTP requests in a SQL Server database. In SharePoint Server 2010, the State Service is required by InfoPath Forms Services (including out of the box and custom workflow forms), the SharePoint Server 2010 Chart Web Part, and certain Microsoft Visio 2010 scenarios that do not use Microsoft Silverlight 3.

The State service application database stores temporary state information for InfoPath Forms Services, the chart Web Part, and Visio Services.

Default database name prefix when installed by using the SharePoint Products Configuration Wizard

StateService

Location requirements

None

General size information, and growth factors

Medium-large. Size is determined by the use of InfoPath Forms services and Visio Services.

Read/write characteristics

Varies

Recommended scaling method

Scale out; add another state database to the service application by using Windows PowerShell cmdlets. For more information, see Manage the State Service (SharePoint Server 2010).

Associated Health rules

None

Supported backup mechanisms

SharePoint Server 2010 backup and recovery, SQL Server, and DPM 2010.

Default recovery model

Full

Supports mirroring within a farm for availability

Yes

Supports asynchronous mirroring or log-shipping to another farm for disaster recovery

No

Comments