Special Edition Using Microsoft

Chapter 25. SQL Server Administration

<feature><title>In This Chapter</title>

• Management Overview 604

• Managing the Server 609

• Managing SQL Server Databases 612

• Managing SQL Server Agent 619

• Optimizing SQL Server Performance 625

• Disaster Recovery Operations 628

• Administration Tips from the Experts 629

• Troubleshooting 632

</feature>

Management Overview

SQL Server is one of the two or three .NET Enterprise Servers that falls on the line between being an administrator’s product and a developer’s product. In SQL Server’s case, that fine line has actually become the province of a special kind of administrator: the Database Administrator, or DBA. Traditional administrators—often lumped into the category “network engineer” or “network administrator”—often lack ...