Federated Database Servers
For databases that must support a highly available system, establishing a federation of database servers lets you spread the processing load across a group of servers by horizontally partitioning the data in a SQL Server database. These servers are managed independently, but cooperate to process requests on the database.
The topics in this section provide the information to help you understand, design, and implement a federation of database servers.
In This Section
Topic |
Description |
|---|---|
Provides an overview of federated database servers and compares their implementation to a single-server system. |
|
Provides general planning guidelines for how to structure your partitions and configure for high availability. |
|
Explains how to implement distributed partitioned views, modify data, and perform backup and restore operations on a federation of database servers. |