safe to drop Distribution db ? -- sql server replication

John A Grandy
10/25/2006 4:10:21 PM

I've noticed that the Distribution db is not present on a fresh instance of
SS05, but then apparently is created on creation of a replication
publication or subscription.

Does anyone know, is it safe to delete the Distribution db ? ( Assuming no
publications or subscriptions are present on the box ).

Hilary Cotter
10/25/2006 10:40:26 PM

No, disable publishing by right clicking on the replication folder in SSMS
and selecting disable publishing and distribution. This will drop the
distribution database in a supported manner.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : safe to drop Distribution db ?