We decided to remove completely replication from the server.
I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication
I also run delete msdb..msdistributiondbs
After all, I do not have any records in
select * from master..sysservers WHERE srvname = 'repl_distributor'
Also GUI shows that I do not have distributor and Replication configured
(but does not give me to reuse existing Distribution DB name if I would
decide to reistablish replication)
The Distribution database is still present (without files) and if I do
select * from sys.databases , I can see distribution database has value "1"
in column "is_distributor". Because of it I can not just drop the
distribution database.
What can I do to remove distribution database?
Thank you
Vad
Use master
Alter DATABASE distribution SET OFFLINE
DROP Database distribution
They actually brought first the database online by using mdb file from dummy
database. May be this step not nessasary