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
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
That depends on what sort of configuration used for database mirroring. http://msdn2.microsoft.com/en-us/library/ms151799.aspx, http://msdn2.microsoft.com/en-us/library/ms190202.aspx and I would like to ask whether do you need use of replicaiton here, if you are looking for additional availability to yoru databases. http://sqlserver-qa.net/tags/database mirroring/default.aspx?PageIndex=3 fyi.