SQL Server Performance

Replicating a replica database

Discussion in 'Performance Tuning for SQL Server Replication' started by akar_anand, Feb 19, 2004.

  1. akar_anand New Member

    Hi,

    I have a requirement of replicating a database which has few replicated tables.
    First, Is it possible to do this? Will there any issues in doing this?
    If no issues,
    What is the better approach and design for this requirement? Also, I would like to know the implementation issues and knowledge sharing.

    Thanks & Regards
    Anand
  2. satya Moderator

    There is a whole section in Books on-line in the Replication section devoted to backup/restore of replicated databases, it may help to replicate those replicated databases.

    I've never tried re-replicating the replicated databases, but I think its not possible.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. vbkenya New Member

    If you are talking about re-replicating a database. YES. Remember that a database can be a subscriber and a publisher at the same time. Every replication scenario occurs independently.

    Issues? The normal issues attendant to replication and a realization that you are now dealing with a more complicated situation. Just keep an eye on what is going on with respect to schedules, agents and PERFORMANCE.

    Approach and Design? Without knowing the actual scenario on your side, it is not possible to offer any useful help. Clear requirements are important for any answer on that (I am sure you are aware of that)

    Knowledge Sharing? Please expand on that one.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com

Share This Page