O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Installing

Let's get started with Snapshot Replication. In this section, we will learn how to install Snapshot Replication. We will later learn about various configuration options of Snapshot Replication.

The very first step is to create the Distributor server and distribution database so that we can set up the Publisher server and publication database on that.

Configuring Distributor and Publisher

Let's see how to configure the Distributor and Publisher step-by-step:

  1. In the left pane of SQL Server Management Studio (SSMS), in the Object Explorer window, connect to the server we wish to set as Distributor. Once we are connected, right-click on Replication Node, select Configure Distribution..., and click Next.
  2. In the Distributor dialog box, we have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required