Post reply

Cannot delete distribution data

  • July 17, 2008 at 9:37 am

    #123224

    I cannot delete distribution database udner system databases. I remember created replication on this server long time back and try to delete distribution database.

  • July 17, 2008 at 9:56 am

    #844511

    have you removed the replication?

  • July 17, 2008 at 10:00 am

    #844513

    Yes,

    How about if i try like this.

    sp_configure 'allow updates', 1

    reconfigure with override

    go

    UPDATE master..sysdatabases SET category = 0 where name='distribution'

    and then delete the distribution database.

  • July 17, 2008 at 11:10 am

    #844548

    Have you disabled that server from being a distributor yet? Right click on replication folder, "Disable Publishing and Distribution"

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • July 17, 2008 at 11:10 am

    #844549

    why not set up replication again and then deleting it again?

  • July 17, 2008 at 12:20 pm

    #844587

    I disable the replication and Distribution database is gone.

    Thanks for all your help.

    Special thanks to David.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply