O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Creating a Transaction Based Publication

SQL Server 2000 provides a Create Publication Wizard to guide when you create a publication. There are many ways you can configure replication in order to fine tune it to your needs

TIP

The creation of your publication will probably progress more smoothly if you have already started your SQL Server Agent and the MS DTC Agent before creating the publication.

Following are the steps you can use to create a typical transactional replication publication:

1.
In Enterprise Manager, make sure that you have the correct server selected. Several SQL Servers might be registered in Enterprise Manager. From the Tools menu, select Replication, and click Create and Manage Publications. When the Create and Manage Publications ...

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