??? Media: Database mirroring involves a complete copy of the database, which you
can maintain in parallel with the production server. If you lose an entire disk
array, no problem??”the entire database exists at the mirror location, wherever
that may be.
??? Process: There is the possibility of protecting against process errors if the mirror
database is running in High Availability mode. In that mode, you can pause mirroring
while performing the process. If the process succeeds, you can resume
mirroring; if the process fails, you can break mirroring and fail over. It isn??™t the
perfect process, but it could work.
??? User: As with process disasters, you might be able to pause mirroring if you can
catch the user disaster in time. That??™s a pretty big ???if,??? though.
Caveats and Recommendations
While database mirroring sounds like a panacea to all disaster scenarios, no technology
or solution is without its own issues. Don??™t forget these tips:
??? Don??™t forget SNAC: To take full advantage of database mirroring, make sure that all
clients have SNAC installed.
??? Choose the appropriate mirroring model: Be aware of all of the needs involved
when choosing a mirror.
Pages:
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422