Still, Microsoft released SQL Server 2005 with database mirroring disabled.
It provided a documented trace flag to enable mirroring if desired, but the company
admitted to not having enough customer feedback to support it for production use.
The feature wasn??™t fully supported until Microsoft released SP1. I appreciate that
Microsoft didn??™t release a feature it wasn??™t sure was stable.
While database mirroring might be called the crown jewel of the SQL Server 2005
platform, that doesn??™t mean it??™s a jewel without flaws. Like any technology, it has its
quirks, unexpected behavior, and oddities. In this chapter, I??™ll take a look at the architecture
of database mirroring, show you how to configure it, compare the different features
it provides (contrary to popular belief, database mirroring is not ???all about availability???),
and explain how it is best used.
Mirroring Architecture
From a purely conceptual level, the basic architecture of database mirroring is quite
simple. In fact, it looks somewhat familiar because it??™s really a functional combination
of clustering and log shipping.
Pages:
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377