IN THIS PART
Chapter 39: Configuring SQL Server
Chapter 40: Managing Policies
Chapter 41: Recovery Planning
Chapter 42: Maintaining the Database
Chapter 43: Automating Database Maintenance with SQL Server Agent
Chapter 44: Transferring Databases
Chapter 45: Database Snapshots
Chapter 46: Log Shipping
Chapter 47: Mirroring
Chapter 48: Clustering
This part is about the enterprise DBA role.
The project isn't done when the production database goes live. A successful database requires preventive maintenance (tune-ups) and corrective maintenance (diligent recovery planning).
The Information Architecture Principle introduced in Chapter 1 presented the idea that information must be secured and made readily available for daily operations by individuals, groups, and processes, both today and in the future.
While SQL Server is more automated than ever before, and Microsoft sometimes makes the error of presenting SQL Server as the database that doesn't require a DBA, the truth is that it takes diligent work to keep a production database up 24 hours a day, 7 days a week, 365 days a year.
If SQL Server is the box, Part VI is about making sure the box holds its shape, day after day.