Post reply

Does replication replicate index rebuild ?

  • September 10, 2014 at 12:07 pm

    #290707

    Hi all.

    We have transactional replication. We have a index rebuilding job on publisher, but subscriber is still highly fragmented.

    Should we create defragmentation job on subscriber, or something is wrong in our replication configuration?

    Thanks

  • September 10, 2014 at 4:48 pm

    #1744611

    SQL Guy 1 (9/10/2014)

    Hi all.

    We have transactional replication. We have a index rebuilding job on publisher, but subscriber is still highly fragmented.

    Should we create defragmentation job on subscriber, or something is wrong in our replication configuration?

    Thanks

    You will need to set up a Defrag at the subscriber. Replication does not handle index maintenance.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply