Replication and Mirroring

• _nzrdb6

  Mr or Mrs. 500

  Points: 580

  More actions

  March 6, 2014 at 9:07 am

  #283072

  Hi guys, I have 3 sql servers A, B, C

  A has the principal DBs. B has the mirror DBs. A replicates to C for reporting purposes. Problem is when there is any latency between A and B, replication cant grab the latest data from A. Is there a better way to architect this so as to avoid replication's dependency on transactions from A being committed at B?

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  March 6, 2014 at 9:18 am

  #1694774

  What's the type of mirroring between A & B ?

  --

  SQLBuddy

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  March 9, 2014 at 7:16 pm

  #1695403

  If I got you trace flag T1448 can help you (to isolate replication from mirror)- check this:

  http://support.microsoft.com/kb/937041