SQL Server Performance

SnapShot in Merge Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by nilayt, Nov 17, 2003.

  1. nilayt New Member

    By Default snapshot run once in a every week..Is it necessary to run
    it once in a week? I have only one subscriber and I don't
    think I'm going to use snapshot folder to syncronize as my
    DB is big and sybscriber is at remote location.

    -Nilay

  2. satya Moderator

    It depends on the requirement and sync. method you use.
    Did you get any issues while synchorinizing?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. nilayt New Member

    Satya,

    Yes, Since we have lot of double quotes ("") in sps & triggers and snapshot by default
    puts ANSI_NULL ON, SET QUOTED_IDENTIFIER ON which causes problem while syncronising..even though all ANSI property are off at server and client levels SQL server does this and I couldn't able to find way to make it off while generating snapshot.

    let me know any suggestion you have..

    Thanks again for your help, Satya.

    -NIlay
  4. satya Moderator

Share This Page