Deleting a Distribution Database
SQL Server 2000 enables you to create multiple distribution databases on the same server. You can delete a distribution database without disabling the server as a distributor. However, when you remove a distribution database, any publications using the database are removed. To delete a distribution database, perform the following:
1. |
Select the server on which you want to delete the distribution database.
|
2. |
From the SQL Enterprise Manager menu, select Tools and then select Replication. A drop-down menu appears. Select the Configure Publishing, Subscribers, and Distribution option. The Publisher and Distributor Properties dialog box appears, shown in Figure 27.9.
Figure 27.9. The Publisher and Distributor Properties ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
