SQL Server Performance

Mirroring & Replication

Discussion in 'SQL Server 2005 Database Mirroring' started by why, Oct 23, 2007.

  1. why New Member

    When using mirroring , remote distributor must be used. Does replication work automatically with fail over server ?
    What can I do with Distributor, now I have 2 publishers (principal and mirror) and 2 subscribers (main and backup) but distributor is single point of failure.
    Distribution database can't be mirrored, clustering has single point of failure (disk). Log shipping with sync with backup option ? what if I cant read last transaction log backup ?
    What can be done ?
    p1-p2
    |
    d1
    |
    s1 s2
    I'm thinking P2Preplication like this: (distribution databases live on nodes)..
    Can it re-replicate using transactional replication to subscribers from different nodes
    p1(d1)<--->p2(d2)
    | |
    s1 s2

    Help
  2. techbabu303 New Member

    Iam not expert on this but based on posts I read sometime back , one of the MVP's has mentioned whic I guess you are aware is clustering provided provides high avulabiliy but does not save from Hard disk failures, so it it needs to coupled with replication or log shipping (quite simliar in nature to mirroring) for high availability.
    In your case if your are going for mirroring no need for replication , yes your second configuration would work logically speaking, but since i have not tried it myself I would be intrested on MVP's opnions on this.
    More on mirroring
    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
    Cheers
    Satish
  3. satya Moderator

Share This Page