SQL Server Performance

sql server replication scripting

Discussion in 'Performance Tuning for SQL Server Replication' started by detroit, Oct 27, 2004.

  1. detroit New Member

    Hey everyone,

    I have a nasty replication scenario in my test and QA environment that I am trying to deal with.

    I have a database replication scenario that goes like this. production_db get replicated (transactional) through a dedicated distributor to a reporting_db. I have to cleanly push a backup of the production database to the QA environment for app validation and still keep the replication scenario intact.

    I am looking for the cleanest way to ensure this works. Here are my ideas.

    IDEA 1
    script the pubs and subs ( create and del )
    drop pubs and subs on both servers from scripts
    restore production db on both servers
    recreate pubs and subs from scripts
    restart replication

    IDEA 2
    script pubs on publisher
    restore production database on publisher
    snapshot changes to subscriber
    restart transactional replication

    Any input would be helpful,

  2. satya Moderator

    I would choose option 1 in order to accomplish the performance and starting from scratch will give benefits.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page