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

Backup Wizard

SQL Server 2000 goes a long way in enabling a casual user to perform standard DBA tasks successfully using wizards. Of course, there is a wizard that enables you to perform a backup. To use the Backup Wizard, perform the following:

1.
From the SQL Enterprise Manager main menu, select Tools and the Wizards option.
2.
The Select Wizard dialog box appears. Click on the + sign next to Management to expand the list of management wizards. Select the Backup Wizard and click OK. The Create Database Backup Wizard dialog box, shown in Figure 10.7, appears.
Figure 10.7. The Create Database Backup Wizard dialog box.

3.
Click the Next button; ...

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