1 out of 3 rated this helpful - Rate this topic

Considerations for Installing SQL Server Replication

SQL Server 2008 R2

Replication components can be installed by using the SQL Server Installation Wizard or at a command prompt. Install replication when you install SQL Server, or when you modify an existing instance.

After replication components are installed, you must configure the server before you can use replication. For more information, see Designing and Implementing (Replication) in SQL Server Books Online.

Important
If you install replication components when you modify an existing instance of SQL Server, you must stop and restart SQL Server Agent after the installation is completed. This action helps ensure that SQL Server Agent recognizes the replication agent subsystems and can call replication agents from job steps.

Installing Replication by Using Setup

To install replication when installing a new instance of SQL Server

To install replication components, including Replication Management Objects (RMO), select SQL Server Replication on the Feature Selection page of the Installation Wizard.

Installing Replication from the Command Prompt

To install replication when installing a new instance of SQL Server

See How to: Install SQL Server 2008 R2 from the Command Prompt.

Concepts

Installing SQL Server 2008 R2

How to: Install SQL Server 2008 R2 from the Command Prompt

Features Supported by the Editions of SQL Server 2008 R2

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD