Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Error Expand / Collapse
Author
Message
Posted Friday, December 08, 2006 5:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 04, 2013 11:06 AM
Points: 397, Visits: 548

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

Post #329056
Posted Friday, December 08, 2006 6:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:35 AM
Points: 1,327, Visits: 4,483

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.




Post #329061
Posted Friday, December 08, 2006 6:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 04, 2013 11:06 AM
Points: 397, Visits: 548

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?

Post #329064
Posted Friday, December 08, 2006 7:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:35 AM
Points: 1,327, Visits: 4,483

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.




Post #329067
Posted Friday, December 08, 2006 7:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 04, 2013 11:06 AM
Points: 397, Visits: 548
once I delete these tables do I need to restart the job or does subscription knows what needs to be done?
Post #329069
Posted Friday, December 08, 2006 7:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 04, 2013 11:06 AM
Points: 397, Visits: 548
unable to delete the table. any other ideas?
Post #329080
Posted Friday, December 08, 2006 3:46 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 4:59 PM
Points: 1,190, Visits: 561

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

 



MohammedU
Microsoft SQL Server MVP
Post #329292
Posted Saturday, July 14, 2012 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 10:40 PM
Points: 6, Visits: 117
You can delete this table. But it will be created at the next restart.
Post #1329766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse