O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 10 High-Availability Strategies

In this chapter, you will learn about:

• Log shipping

• Database snapshots

• Database mirroring

• Replication

• Clustering

Any sufficiently advanced technology is indistinguishable from magic.

—Clarke's Third Law

While not exactly magic, to the uninitiated, many of the strategies used to maintain separate copies of databases certainly seem to be magical. An entire database could go down, but the end user is barely aware there was even a problem.

image TIP This chapter deals with high availability, and the only way to demonstrate this is with two separate instances of SQL Server. In the real world, this would ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required