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.
| 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 beforeAny thoughts ?Bill Orova |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-11 : 13:03:48
|
| What is the actual error message? |
 |
|
|
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/3724Cannot drop the table 'dbo.yard_position_log' because it is being used for replication. (Source: MSSQLServer, Error number: 3724)Get help: http://help/3724 |
|
|
|
Rhumbline
Starting Member
5 Posts |
Posted - 2013-04-11 : 13:07:53
|
| No replicated transactions are available. |
|
|
|
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? |
|
|
|
Rhumbline
Starting Member
5 Posts |
Posted - 2013-04-11 : 13:17:27
|
| this is under distibuter to subscriber history |
|
|
|
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 |
|
|
|
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. |
|
|
|
|
|
|
replication distrubuter