SharePoint 2010 Secure Store database

November 24, 2010 — Leave a comment

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

Secure_Store_Service_DB_

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

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

Yes


 

No Comments

Be the first to start the conversation!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s