When to Use Database Mirroring
As mentioned earlier in this chapter, database mirroring elevates the availability level of a SQL Server–based application to a very high level without any special hardware and extra administration staff skills. However, when you should use database mirroring varies depending on your true needs.
Basically, if you need to increase the availability of the database layer, have automatic data protection (that is, redundant storage of data), or decrease the downtime that would normally be required to do upgrades, you should use database mirroring. An ever more popular scenario for database mirroring is when you need to offload reporting that is easily satisfied with periodic database snapshots. This usage provides great ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
