Online Documentation for SQL Administrator for SQL Server
Backup Database Wizard
Backup Database Wizard allows you to perform the database backup operation on your SQL Server system (the BACKUP DATABASE Transact-SQL statement is issued).
This operation is used to create a backup copy of the entire database, transaction log or files/filegroups.
To run the wizard select the Tools | 
Backup Database... main menu item or click Backup Database... button on the toolbar. Alternatively, you can right-click the database alias in the list of databases and select the Backup Database... item of the context menu.
The wizard consists of the following steps:
- Selecting server
- Setting backup type
- Selecting database to backup
- Selecting database files to backup
- Selecting backup devices
- Setting backup media options
- Setting backup options
- Setting schedule options
- Running database backup
