SharePoint 2010 Secure Store database

Secure Store database

The Secure Store service application database stores and maps credentials, such as account names and passwords.

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


Location requirements

For secure credential storage, we recommend that the secure store database be hosted on a separate database instance or database server that has access limited to one administrator. By default, if the database is hosted on the default SharePoint database server and instance, all database administrators will have access to the secure store database.

General size information, and growth factors

Medium. Size and growth are determined by the number of target applications, number of credential fields per target application, and the number of users stored in each target application.If auditing is turned on, the number of read/write operations performed against a given target application also affects size.

Read/write characteristics

Equal read/write ratio

Recommended scaling method

Scale up the database that supports the service application instance. You can scale out by creating additional instances of the service application, however, the decision to create a separate service application is likely to be based on business, rather than scale, requirements.

Associated Health rules


Supported backup mechanisms

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

Default recovery model


Supports mirroring within a farm for availability


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



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s