??? Server A is the principal.
??? Server B is the mirror.
??? Server C is playing the role of a witness.
Figure 8-10. Client connection to the principal and the relationships between the principal,
the mirror, and the witness
This transfer happens each time the client connects initially. If the configuration
changes and you have a new server as the witness??”say, Server D??”the client will
learn of it.
The connection string for the 2005 OLE DB driver??”I??™m sorry, SNAC (I love saying
that for some reason)??”includes a spot to designate the location of the mirror database.
CHAPTER 8 n DATABASE MIRRORING 205
Data Source=Mirror1;Failover Partner=Mirror2;
Initial Catalog=MirrorTest;Integrated Security=True;
The Failover Partner is a fallback in the event that the client doesn??™t have or somehow
loses the name of the other failover partners. SNAC automatically collects that information
when it connects to the principal, so when would you ever need this setting in the
SNAC connection string? Actually, you??™ll need that hard-coded failover partner more
often than you think.
Pages:
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393