sql server replication: Replication -- sql server replication

Replication

anonymous NO[at]SPAM discussions.microsoft.com
12/30/2003 10:30:03 AM

sql server replication: I'm evaluating several replication possibilities, is
anyone aware if SQL Server replication identifies database
corruption before it goes and replicates it? For
instance, if the server I am replicating has a database
that is corrupted, I do not want that corrupted database
to be replicated. Does SQL Server replication know not to
replicate the corruption? If not, can anyone suggest a
tool that would recognize the corruption and then stop the

Re: Replication

Hilary Cotter
12/31/2003 10:18:07 AM

replication does no dbcc checkalloc before replicating data.

You would have to write some job that does this before the distribution
agent runs.

SQL Server will not replicate a corrupted table as it will be unable to read
the corrupted rows. In fact a lot of customers use replication to implement
fault tolerance.

[quoted text, click to view]