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 Transactional Replication

In this section we will learn how to install Transactional Replication using wizard and using T-SQL. We will also learn about which account should be used to run SQL Server Agent.

Creating new publication for Transactional Replication

Let's start installing transactional replication by creating a new publication.

  1. We need to connect to the server on which we want to create publication. Expand the replication node, right-click on Local Publication, and select New Publication.
    Creating new publication for Transactional Replication
  2. In the Publication Database dialog box, select the database to be published.
  3. In the Publication Type dialog box, select the Transactional replication. ...

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