SQL Server Performance

Intial Snapshot

Discussion in 'Performance Tuning for SQL Server Replication' started by nilayt, Jul 28, 2003.

  1. nilayt New Member

    Hi,

    If I Generate snapshot and then take backup of publisher
    databse and restore to subscriber, Is that going to work?
    What is best way to handle this?

    Thanks
    Nilay
  2. tkelley New Member

    Are you trying to initially setup replication?

    You should do a backup and restore to subscriber before setting up replication.

    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  3. nilayt New Member

    Thanks Kelley,

    But I've to take Intial snap shot to insert new unique identifier column.

    Are you suggesting adding this column first and then take backup on publisher
    and restore on subscriber and then generate snapshot and set up subscrpting to this publiscation?

    Thanks

    Nilay
  4. tkelley New Member

    No, perform the backup of Publisher and restore to subscriber first, then set up replication. The setup process creates the unique identifiers for you on both the publisher and subscriber.

    Make sense?

    Try MSDN or BOL for more info on setting up replication.

    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  5. satya Moderator

Share This Page