SQL Server Performance

Intial Replication -URGENT REq

Discussion in 'SQL Server 2005 Replication' started by SQLDBAS, Mar 30, 2007.

  1. SQLDBAS New Member

    Hello there,
    Could someone help on suggest what would be the best option
    I have 60 GB Databse I am setting first time replication.
    1. Copy /restore the production on subscriber ? What are all manual steps do I need to take care this thing to work .
    2. Go ahead with regular replciation setps.[ Any idea how long it will take]
    Your help would be really helpful.
  2. ndinakar Member

  3. SQLDBAS New Member

    Sorry we are going to use SQL 2005
  4. MohammedU New Member

  5. bertcord New Member

  6. SQLDBAS New Member

    At last implemented the replication. I missed for to set one table not for replication =YES ( subscriber database)
    I am going to create temp table copy all records from orignal tbl to temp tble
    then drop orignal table . rename temp to orig
    all these activities on subscriber table . Does it affect any thing? on replication?

    Distributor remembers ID'd subscirer database tables?

    Any help would be really appreicate..
  7. satya Moderator

    I can see that will slow down the replication and other than this it shouldn't affect at all.
    If its not a problem thne why not reinstate replication with relevant settings.

    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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page