Deploying a Scalable Shared Database

Describes the benefits and restrictions of the Scalable Shared Database feature. Describes the processes that are required to build and update the reporting database.

Contains guidelines and recommendations for preparing your environment for scalable shared databases.

Describes recommendations for building the reporting database, introduces data-copy methods provided by SQL Server 2005 and later versions for copying data or databases, and describes the steps for building or refreshing a database on a set of reporting volumes.

Describes using two, alternate sets of reporting volumes to decrease downtime for a reporting database.

Describes the steps of the removing a stale reporting database from a scalable shared database configuration and summarizes alternative strategies.

Describes the steps for scaling out a reporting database as a scalable shared database.