SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Summary

In this chapter, you learned to implement several high-availability and redundancy features. First, you learned about the importance of internal availability through the illustration of hard drive RAID configurations. Next, you learned to implement database mirroring for data redundancy. Database mirroring is considered a low-latency availability feature because the updates to the mirror database are transactional in nature—meaning they happen as they occur on the primary server. The next topic addressed was log shipping. Log shipping also provides data redundancy, but it is considered high latency. Finally, you learned to implement snapshots, which can be used to provide copies of your database at points in time. The snapshots can be ...