Post reply

Replication Error

  • December 8, 2006 at 5:39 am

    #91946

    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

  • December 8, 2006 at 6:28 am

    #676864

    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.

  • December 8, 2006 at 6:52 am

    #676867

    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?

  • December 8, 2006 at 7:08 am

    #676870

    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.

  • December 8, 2006 at 7:13 am

    #676872

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

  • December 8, 2006 at 7:33 am

    #676881

    unable to delete the table. any other ideas?

  • December 8, 2006 at 3:46 pm

    #677069

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

     

    MohammedU
    Microsoft SQL Server MVP

  • July 14, 2012 at 7:46 am

    #1512791

    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