• because I do not have a Subscriber backup, when restoring my Publisher database I first delete replication settings

    exec sp_removedbreplication

    -- Dropping the registered subscriber

    exec sp_dropsubscriber @subscriber = N'SRV'

    -- Dropping the distribution publishers

    exec sp_dropdistpublisher @publisher = N'SRV'

    -- Dropping the distribution databases

    use master

    exec sp_dropdistributiondb @database = N'distribution'

    GO

    /****** Uninstalling the server as a Distributor. ******/

    exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1

    restore Publisher db and re-create replication (using script previously generated with Management Studio )

    this is the ony solution I've got


    Kindest Regards,

    egpotus DBA