Implementing Federated Database Servers

The topics in this section provide the information to help you create a federation of database servers, modify its data, and perform backup and restore operations.

In This Section

Topic Description

Creating Distributed Partitioned Views

Explains the mechanics of how to create a set of partitioned views and distribute them across servers by using linked server definitions.

Modifying Data in Partitioned Views

Explains what is needed for a distributed partitioned view to be updatable, and also the requirements for the INSERT, UPDATE and DELETE statements.

Backing Up and Restoring Federated Database Servers

Describes what you must know about performing backup and restore operations on a federation of database servers

See Also

Concepts

Federated Database Servers

Help and Information

Getting SQL Server 2005 Assistance