SQL Server™ 2005 Bible

Part IV. Enterprise Data Management

In This Part

• Chapter 34

• Configuring SQL Server

• Chapter 35

• Transferring Databases

• Chapter 36

• Recovery Planning

• Chapter 37

• Maintaining the Database

• Chapter 38

• Automating Database Maintenance with SQL Server Agent

• Chapter 39

• Replicating Data

• Chapter 40

• Securing Databases

• Chapter 41

• Administering SQL Server Express

Part IV 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 that 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 IV is about keeping the box running smoothly, day after day.