Deleting replication, leaves data in distribution database

Hi,

>From a publisher I replicate 3 databases to a distributor/subscriber
machine. On all of them i have MS SQL 2005.
When i delete one of the replications by running
publisher => sp_dropsubscription
subscriber/distributor=>sp_removedbreplication
publisher => sp_removedbreplication
subscriber/distributor =>sp_subscription_cleanup
On the publisher and subscriptions databases all replication things
are removed.
However when looking with the replication monitor the deleted
replication is visible with a big red cross. Also the jobs are still
in the job list of the distributor!
When removing everything by dropping the distribution database all is
cleared. I know that in SQL 2000 the distributor would also be
cleared. Has this changed?
Is this a bug in SQL2005 or am i forgotting something (i have searched
a lot already, but cannot find anything)?
Hopefully someone can help me?
Marcel
I'd recommend using sp_droppublication which'll clean up the jobs as well.
sp_removedbreplication is something I run only occasionally to clean up any
remaining orphaned objects.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||On 1 feb, 10:28, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I'd recommend using sp_droppublication which'll clean up the jobs as well.
> sp_removedbreplication is something I run only occasionally to clean up any
> remaining orphaned objects.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
Thanks Paul,
This looks much better! I finalized with
EXEC sp_replicationdboption
@.dbname = @.publicationDB,
@.optname = N'publish',
@.value = N'false';
This should remove the publication objects...
Marcel

Deleted 1 report in SQL server report manager

Hi,
I deleted 1 report [Account distribution] in SQL server report manager
[2005]. Please let me know if there is a way to recover this.
Thanks,
-SekharOn May 25, 1:08 pm, Sekhar <Sek...@.discussions.microsoft.com> wrote:
> Hi,
> I deleted 1 report [Account distribution] in SQL server report manager
> [2005]. Please let me know if there is a way to recover this.
> Thanks,
> -Sekhar
Refer to Norman's response on your other posting, as far as I know, he
is correct.
Regards,
Enrique Martinez
Sr. Software Consultant

delete unnecessary agents

hello,
there are many "dead" agents (snapshot, protocoll,distribution) in my
enterprise manager of deleted replications ... how can i delete these
agents as well?
thx for help
Alex
has nobody an answer?
"Alexander Widera" <awid@.hrz.tu-chemnitz.de.invalid.de> schrieb im
Newsbeitrag news:e6QVJs7eFHA.3836@.tk2msftngp13.phx.gbl...
> hello,
> there are many "dead" agents (snapshot, protocoll,distribution) in my
> enterprise manager of deleted replications ... how can i delete these
> agents as well?
> thx for help
> Alex
>