Microsoft® SQL Server® 2012 Bible

661

CHAPTER

26

Log Shipping

IN THIS CHAPTER

Confi guring a Warm Standby Server Using Management Studio and Transact-SQL

Monitoring Log Shipping

Modifying or Removing Log Shipping

Switching Roles

Returning to the Original Primary Server

T

he availability of a database refers to the overall reliability of the system. The Information

Architecture Principle, discussed in Chapter 2, “Data Architecture,” lays the foundation for

availability in the phrase readily available. The defi nition of readily available varies by the

organization and the data. A database that’s highly available is one that rarely goes down. For

some databases, being down for an hour is not a problem; for others, 30 seconds of downtime is a

catastrophe. Organization requirements, budget constraints, and other resources dictate the proper

solution.

Of course, availability involves more than just the database; there are several technologies involved

outside of the database: the instance, the server OS, the physical server, the organization’s infra-

structure, and so on. The quality and redundancy of the hardware, quality of the electrical power,

preventive maintenance of the machines and replacement of the hard drives, security of the server

room — all these contribute to the availability of the primary database. An IT organization that

intends to reach any level of high availability must also have the right people, training, policies,

and service-level agreements (SLAs) in place.

This chapter is the fi rst of a series of chapters dealing with high-availability technologies: Log Shipping, Database Mirroring,

AlwaysOn Availability Groups and Clustering. Backup and Recovery, along with Replication; and even Azure SQL Database (SQL

Server in the cloud) with Azure SQL Database Data Sync are also part of the availability options. A well-planned availability

solution considers every option and then implements the technologies that best fi t the organization’s budget and availability

requirements. Log shipping has not changed much since SQL Server 2008 R2 so if you’re familiar with this feature this chapter

should be more of a review for you.

c26.indd 661c26.indd 661 7/31/2012 9:49:15 AM7/31/2012 9:49:15 AM

http://www.it-ebooks.info