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,

    THX
  2. satya Moderator

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

    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.

Share This Page