syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

Database Mirroring

One of the things I'm investigating is DR, actually not really disaster recovery, more of a "service availability" problem.  I'm not trying to address the DR situation yet, just the "OMG SERVER CRASH" problem.

So I started doing research on clustering vs mirroring, since I hadn't done it before.  If you're researching mirroring, start here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

That's a technet whitepaper on mirroring.  After you're done with that, go here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx

Performance implications of mirroring, along with best practices stuff.  The interesting part of the second paper is the performance implications of  the encryption options (negligible impact, should always be turned on).  I found it fascinating anyway.

Print | posted on Wednesday, June 27, 2007 11:19 AM |

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET