O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required