SQL Server Performance

Applying New Index to Replicating Table

Discussion in 'Performance Tuning for SQL Server Replication' started by sergiomdiv, Mar 4, 2004.

  1. sergiomdiv New Member

    Hi Guys,

    Applying New Index to Replicating TableI really need your help on this, I have 3 databases that are replicating. I want to apply new indexes to certain tables, do i still need to re-do the replication setup?

    Thank
    Serge
    sergiomdiv, Mar 4, 2004
    #2

  2. satya Moderator

    satya, Mar 4, 2004
    #2

  3. sergiomdiv New Member

    Thank you very much Satya. Btw, so I will just create the script that will update my 3 database(table)indices and apply it to them?<br /><br /><br />More power![<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
    sergiomdiv, Mar 5, 2004
    #2

  4. satya Moderator

    satya, Mar 5, 2004
    #2

  5. sergiomdiv New Member

    We are using SQL Server 2000 Enteprise Ed. for the Main Server(Win 2003) while the other two remote servers is Personal Edition running on Win2k.
    sergiomdiv, Mar 5, 2004
    #2

  6. Twan New Member


    As far as I'm aware, you'd have to create the indexes manually on all 3 databases

    Cheers
    Twan
    Twan, Mar 6, 2004
    #2

  7. satya Moderator

    Yes as specified execute'em manually on involved database/tables.
    As its SQL 2K no need to refresh the replication setup for any changes occured on the table(s).

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 7, 2004
    #2

Share This Page