Database Maintenance Plan Wizard
The Database Maintenance Plan Wizard automates many of the common jobs a DBA normally performs. Before this wizard was developed, many DBA jobs were script based. With this wizard, however, you can now graphically automate backups, DBCC commands, and other administrative functions. A nice feature of the Database Maintenance Plan Wizard is that it can email results to an operator.
The following steps explain how to use the Database Maintenance Plan Wizard:
1. |
From the SQL Server Enterprise Manager, click the Run a Wizard toolbar button. The Select Wizard dialog box appears (see Figure 12.30).
Figure 12.30. The Select Wizard dialog box. |
2. |
From the Select Wizard dialog box, Click the plus (+) sign next to the ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
