How to create a database backup (Enterprise Manager)
To create a database backup
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database, point to All Tasks, and then click Backup Database.
- In the Name box, type the backup set name. Optionally, in Description, type a description of the backup set.
- Under Backup, click Database - complete.
- Under Destination, click Tape or Disk, and then specify a backup destination.
If no backup destinations appear, click Add to add an existing destination or to create a new one.
- Under Overwrite, do one of the following:
- Click Append to media to append the backup to any existing backups on the backup device.
- Click Overwrite existing media to overwrite any existing backups on the backup device.
- Click Append to media to append the backup to any existing backups on the backup device.
- Optionally, select the Schedule check box to schedule the backup operation for later or periodic execution.
- Optionally, click the Options tab and do one or more of the following:
- Select the Verify backup upon completion check box to cause the backup to be verified when backed up.
- Select the Eject tape after backup check box to cause the tape to be ejected when the backup operation has completed. Available only with tape devices.
- Select the Check media set name and backup set expiration check box to cause the backup media to be checked to prevent accidental overwrites. In Media set name, type the name of the media to be used for the backup operation. Leave blank when specifying only the backup set expiration.
- Select the Verify backup upon completion check box to cause the backup to be verified when backed up.
- If it is the first use of the backup media, or you want to change an existing media label, under Media set labels, select the Initialize and label media check box and type the media set name and media set description. The media can be initialized and labeled only when overwriting the media.
See Also
Backing Up the master Database