Replication Error

  • I am running replication from a clustered sql server to an instance of sql on a diff. box. When I performed failover on the source cluster replication broke. Publisher seems to work fine. However on the subscriber I get following error message:

     

    Invalid object name 'tempdb.dbo.MSdistributor_access'.  The step failed.

    any idea how to troubleshoot this? Seems like there is not much on this online.

     

    Thanks

  • Where are you seeing this error?

    This table (and a few others) are used to populate the information in Replication Monitor, and don't actually have anything to do with the replication process itself.

    If you delete these files from Tempdb, and refresh Replication Monitor, they just get rebuilt.

  • I am seeing this in the job history as well as under the last action column of subscription window.

    do you mean i should delete all the records from MSdistribution_access table or delete the table?

  • Delete the tables.

    Don't forget, the tables are in Tempdb, so they will be removed every time you restart the instance, so you can do no harm by deleting the whole table.

  • once I delete these tables do I need to restart the job or does subscription knows what needs to be done?

  • unable to delete the table. any other ideas?

  • 'tempdb.dbo.MSdistributor_access' table might be marked as system table so that you can't delete it.

     

    MohammedU
    Microsoft SQL Server MVP

  • You can delete this table. But it will be created at the next restart.

Viewing 8 posts - 1 through 7 (of 7 total)

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