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 and Assigning the Distribution Database

Now that you have an overview of SQL Server replication, examine how to set up replication. First, examine how to create or specify the distribution database.

NOTE

Creating a distribution database requires sysadmin permission.

To create a distribution database, follow these steps using the SQL Enterprise Manager:

1.
Select the server on which you want to install the distribution database.
2.
From the SQL Enterprise Manager menu, select Tools and then select Replication. A drop-down menu appears (see Figure 27.3). Select the Configure Publishing, Subscribers, and Distribution option. You can also right-click the Replication folder and choose Configure Publishing, Subscribers, and Distribution. ...

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