Deploying a Scalable Shared Database

The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on a set of dedicated, read-only volumes whose primary purpose is hosting the database. By using commodity hardware for servers and volumes, you can scale out a reporting database that provides the same view of the reporting data on multiple reporting servers. This feature also allows a smooth update path for the reporting database. For more information, see Scalable Shared Databases Overview.

Scalable Shared Databases Overview

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

Ensuring a Correct Environment for a Scalable Shared Database

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

Building or Refreshing a Reporting Database

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.

Maximizing Availability of a Scalable Shared Database

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

Detaching a Scalable Shared Database

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

Attaching a Reporting Database as a Scalable Shared Database

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

Community Additions