In this chapter, you will learn about:
• Log shipping
• Database snapshots
• Database mirroring
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.
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 ...