Export (0) Print
Expand All

How to create a database backup (Enterprise Manager)

SQL Server 2000

How to create a database backup (Enterprise Manager)

To create a database backup

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database, point to All Tasks, and then click Backup Database.

  3. In the Name box, type the backup set name. Optionally, in Description, type a description of the backup set.

  4. Under Backup, click Database - complete.

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

  6. 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.
  7. Optionally, select the Schedule check box to schedule the backup operation for later or periodic execution.

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

Appending Backup Sets

Backing Up the master Database

Backing Up the model, msdb, and distribution Databases

Copying Databases

Transaction Log Backups

Database Backups

Differential Database Backups

Deleting a Database

Overwriting Backup Media

Reducing Recovery Time

Initializing Backup Media

Verifying Backups

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft