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
 General SQL Server Forums
 New to SQL Server Administration
 Truncation of table is stopping replication

Author  Topic 

venug
Starting Member

3 Posts

Posted - 2013-01-23 : 01:57:05

When a table which is not involved in replication is truncated its stopping the replication activity.

Please advice.

Regards.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-23 : 02:05:10
hmm...thats a bit strange
Is it using TRUNCATE or DELETE FROM statement?
If latter, does it have a trigger in place?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

venug
Starting Member

3 Posts

Posted - 2013-01-23 : 02:11:44
No triggers on the table,neither being used for reference in any table.
Go to Top of Page

ovc
Starting Member

35 Posts

Posted - 2013-01-26 : 12:40:53
which type of replication are you using? The thing is truncate does not log the "delete rows" in the database log file. That is why there might occur some inconsistencies and the replication stops. Try to use delete from. This should not cause this issue, if I am assuming right.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-01-29 : 11:13:37
run a trace. i bet it's something else.

you can't truncate a replicated table, and a truncate of a table not part of the publication shouldn't have any effect.

why do you think that the truncate is causing replication to stop?
Go to Top of Page
   

- Advertisement -