SQL Server Performance

Subscriber with Schema and Data

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

  1. krajdba New Member

    Hi Gurus,

    I am setting up replication on a 100+GB database. In the Push Subscriber wizard
    I wanted to use " No, The Subscriber Agent already has the schema and data" option.

    Could you please explain what are the things i have to consider and if you could
    provide a link for this will be great.

    Thanks & Regards



    raj
  2. satya Moderator

    http://www.replicationanswers.com/NoSyncOn2005.asp fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    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.
  3. krajdba New Member

    Hi Satya,

    My question actually should have been."How to create the subscriber
    database using backup" and how to publish data from publisher to
    subscriber and all the parameters to maintain subscriber db?
    Very very Urgent Please. A good link will help me a lot.

    Thanks & Regards



    raj
  4. satya Moderator

    May be KBAhttp://support.microsoft.com/kb/320499 and also search I think recently posted such information.
    http://www.codeproject.com/database/MergeReplication.asp for merge.
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22252 relevant post.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    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.

Share This Page