Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Replication (2012)
 replication distrubuter

Author  Topic 

Rhumbline
Starting Member

5 Posts

Posted - 2013-04-11 : 11:53:25
Yes Hello we have a replicated set of sql servers that have now failed for the first time we viewd the monitor and it said the last article was not valid. We removed it from the list now it still fails saying the next article is to be removed ... We have not removed it as this has not happened before
Any thoughts ?
Bill Orova

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-11 : 13:03:48
What is the actual error message?
Go to Top of Page

Rhumbline
Starting Member

5 Posts

Posted - 2013-04-11 : 13:07:17
The job failed. The Job was invoked by User SEPTAAD1\asws. The last step to run was step 3 (Detect nonlogged agent shutdown.). The job was requested to start at step 1 (Distribution Agent startup message.).

Cannot drop the table 'dbo.yard_position_log' because it is being used for replication. (Source: MSSQLServer, Error number: 3724)
Get help: http://help/3724
Cannot drop the table 'dbo.yard_position_log' because it is being used for replication. (Source: MSSQLServer, Error number: 3724)
Get help: http://help/3724
Go to Top of Page

Rhumbline
Starting Member

5 Posts

Posted - 2013-04-11 : 13:07:53
No replicated transactions are available.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-11 : 13:11:18
What is trying to drop yard_position_log?

This isn't a replication error.

Have a look at the agent logs, msrepl_errors and the application event logs.

Did you try to drop articles that are published?
Go to Top of Page

Rhumbline
Starting Member

5 Posts

Posted - 2013-04-11 : 13:17:27
this is under distibuter to subscriber history
Go to Top of Page

Rhumbline
Starting Member

5 Posts

Posted - 2013-04-11 : 13:18:54
yes this is the second article from the bottom we droped the other one (first one)then it jumped up to the next from the bottom of the list
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-11 : 15:12:22
How did you drop it?

You may need to drop the subscriptions and recreate the the publication at this point...hard to say without knowing exactly what you've done. Tried re-snapshotting?

Might as well script out the publication and post that here too so we can see what you have.
Go to Top of Page
   

- Advertisement -