Distribution database files were lost because of the disk failure.
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
Vad - 26 Aug 2008 01:31 GMT
Forgot to mention that I am talking about SQL 2005
> Distribution database files were lost because of the disk failure.
>
[quoted text clipped - 17 lines]
> Thank you
> Vad
Vad - 27 Aug 2008 19:04 GMT
Paied to MS to get this done:
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
> Forgot to mention that I am talking about SQL 2005
>
[quoted text clipped - 19 lines]
> > Thank you
> > Vad