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.
