Post reply

Distributor not available, but need to remove databases involved in replication.

  • January 29, 2009 at 8:24 am

    #103670

    Hello all,

    I need to remove some old databases from server A.

    These databases have been involved in snapshot replication. The distribution server for this replication has been taken offline, without removing the replication from these databases.

    The Configure Publishing, Subscribers, and Distribution screen does not open; instead, I get an error window saying 'The Distributor is not available. Error 17: SQL Server does not exist or access denied.'

    Is there a workaround to remove the replicated from server A?

    tia,

    Hans

  • April 27, 2009 at 3:56 am

    #984239

    Hello all,

    I still have the same situation; I wonder if there even is an answer to this question.

    Has anyone come across the same situation?

    tia,

    Hans

  • May 8, 2009 at 12:03 pm

    #991370

    you want to remove the replication right?

    if yes:

    sp_removedbreplication "DB Name"

    and restart you services...

    HTH

    Vinay

    Thanx.
    Vinay

    http://rdbmsexperts.com/Blogs/
    http://vinay-thakur.spaces.live.com/
    http://twitter.com/ThakurVinay

  • June 23, 2009 at 8:11 am

    #1013963

    Thank you Vinay,

    this was exectly what I was looking for,

    regards,

    Hans

Viewing 4 posts - 1 through 3 (of 3 total)

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