Monday, March 19, 2012

Applying DBCC DBREINDEX on a database that is part of Transaction Replication

I am about to apply DBCC DBREINDEX to a large database that is part of transactional replication and synchronised every 3 minutes. What are the likely implication and what precautions I must take.

Thanks in advance

Regards

R Suresh

Logreader will not replicate the index rebuild operation. Also if you use SQL 2005, I recommend you to use ALTER INDEX to rebuild index because DBCC DBREINDEX is a deprecated feature.

Of course, you need to do some experiment to see the performance impact if you do it frequently.

Peng

No comments:

Post a Comment