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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-26 : 10:10:50
|
| james writes "hi! I have set up transactional replication between two sql 7 databases, everything is working. But whenever some insert statement which is valid in publisher database but not in subscriber database occurs then distribution agent fails with foreign key contstraints error, when I try to restart it fails again(obviously its still trying to insert same row which caused error at first place). Now my question is can I somehow make it to start replicating only new dml statements and forget about the violating record. In other words to set up log reader agents to restart loging only the new records and restarting distribution agent. I appreciate any hint. Thanks." |
|
|
|
|
|
trouble in restarting distribution agent after failure