Post reply

I cant delete replication in my server (MISSING SYS VIEWS???

  • March 30, 2010 at 3:34 am

    #220968

    If I try to delete manually the system shows the next popup

    (sorry for the screenshor in spaniosh)

    If you try to delete the replicacion with the next query:

    use [master]

    exec sp_dropdistributor @no_checks = 1

    GO

    The system throws the next error:

    Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 337

    El nombre de objeto 'sysarticles' no es válido.

    Mens 4413, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 337

    No se pudo usar la vista o función 'sysextendedarticlesview' debido a errores de enlace.

    Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 406

    El nombre de objeto 'sysarticles' no es válido.

    Mens 4413, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 406

    No se pudo usar la vista o función 'sysextendedarticlesview' debido a errores de enlace.

    Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSpublishdb, Línea 123

    El nombre de objeto 'syssubscriptions' no es válido.

    Many thanks...

  • April 6, 2010 at 3:23 pm

    #1146829

    You haven't specified if the distributor and publisher are on the same box. Anyway, the errors are there because sp_dropdistributor is trying to clean some leftover subscriptions and publications from some databases. If you are at a point where you have to just clean your server of replication, you can run sp_removedbreplication in each database to cleanup any leftover replication objects in any of the databases.

    You should be able to run sp_dropdistributor then fine. Let me know if that helps.

Viewing 2 posts - 1 through 2 (of 2 total)

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