Server Management

The Management folder contains subfolders for the SQL Server agent, backup devices, current activity, database maintenance plans, and error logs. Each of these plays a key role in managing your server.

SQL Server Agent

The SQL Agent is the “quarterback” when it comes to maintenance tasks. It handles the automation of SQL Server operations. General tasks such as starting and stopping the agent can be accessed from the right-click pop-up menu, as can configuration through the Properties dialog box. Figure 4.12 displays the Agent Properties dialog box.

Figure 4.12. Configuring the SQL Server Agent.

Subfolders for alerts, operators, ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.