Chapter 26
Log Shipping
In This Chapter
Configuring 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
The 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 definition 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 infrastructure, 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.
Get Microsoft SQL Server 2012 Bible 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.