SQL Server Performance

Any way to skip snapshot in merge replication?

Discussion in 'Performance Tuning for SQL Server Replication' started by sql_er, Jun 18, 2007.

  1. sql_er New Member


    I am considering to set up a merge replication. The issue is that the tables I plan to replicate are too big (~50GB) in total. I think that snapshot agent will take forever to copy them over to the subscriber.

    Is there a way to avoid this [i.e. maybe restore the database at the subscriber] and then somehow make the necessary tables part of the merge replication.

    Please advise

    Thanks a lot
  2. MohammedU New Member

    You can backup and restore the databse or manually copy the tables and when you configure the subscription choose the option "Subscriber has the schema and data" to avoid snapshot...


    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    If the link between them is good then you could take help of dynamic snapshothttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx andhttp://www.sql-server-performance.com/merge_replication.asp too.

    KBAhttp://support.microsoft.com/kb/320499 on what Mohammed referred.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. sql_er New Member

    Mohammed - thanks for the useful info

    Satya - thanks for the great links - i skimmed through - they look very useful - will read in more details once implementing

Share This Page