Chapter 12

Data Availability and Distribution

What's the use of having a database if you can't access your data when you need it? In today's world of mission-critical database applications and 24/7 businesses requiring minimum downtime, the job of DBA is more challenging than ever before. You not only have to create a great database application, you also have to make sure that it is up and available when anyone needs it.

The cousin to availability is data distribution. Sometimes the issue is not as much about having constant uptime as it is the distribution of data to the consumer who needs it. In some cases, the same solutions as those used for availability are appropriate. In others, you will need new solutions to solve the data-distribution ...

Get Mastering SQL Server® 2008 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.